> Date: Thursday, March 16, 2017 13:04:24 +0100
> From: "Erik P. Olsen" <epodata AT gmail DOT com>
>
> On 2017-03-16 at 11:10:10 Richard wrote:
> 
>> > Date: Thursday, March 16, 2017 08:00:26 +0100
>> > From: "Erik P. Olsen" <epodata AT gmail DOT com>
>> > 
>> > On 2017-03-15 at 21:17:07 Dan Langille wrote:
>> >   
>> >> > On Mar 14, 2017, at 2:42 AM, Erik P. Olsen <epodata AT gmail DOT com>
>> >> > wrote:
>> >> > 
>> >> > On 2017-03-13 at 22:52:04 Richard wrote:
>> >> >     
>> >> >> What you have for privileges is what I would expect. My
>> >> >> "grant_mysql_privileges" script has two lines - the first
>> >> >> will do the "localhost" setup for the bacula user. Assuming
>> >> >> that your script is lacking that, you might want to add it
>> >> >> and try rerunning the script.
>> >> >> 
>> >> >> grant all privileges on ${db_name}.* to ${db_user}@localhost
>> >> >> ${pass}; grant all privileges on ${db_name}.* to
>> >> >> ${db_user}@"%" ${pass};    
>> >> > 
>> >> > 
>> >> > In my script the lines are:
>> >> > 
>> >> > use mysql
>> >> > grant all privileges on ${db_name}.* to ${db_user}@localhost
>> >> > ${pass} ${ssl_options};  grant all privileges on ${db_name}.*
>> >> > to ${db_user}@"%" ${pass} ${ssl_options};  select * from user;
>> >> > flush privileges;
>> >> > 
>> >> > Ups, I now see that a semicolon is missing after "use mysql". 
>> >> > I'll add it and rerun the script:
>> >> > Oh it won't let me do the "use mysql;" Access denied.    
>> >> 
>> >> 
>> >> Perhaps connect to mysql using the user name / password you have
>> >> in the Catalog definition.  
>> > 
>> > [erik@Erik-PC ~]$ mysql bacula --user=bacula
>> > ERROR 1044 (42000): Access denied for user ''@'localhost' to
>> > database 'bacula'
>> > 
>> > I am afraid it will never work :-(  
>> 
>> > From the output you provided, the "grant" script that you are
>> > running  
>> doesn't appear to be giving access permissions to bacula@localhost
>> - though seems to be for bacula@%. You might just want to look at
>> the bacula@% records and (manually) enter matching ones for
>> bacula@localhost. I suspect that that will at least get you on to
>> the next step.
> 
> MariaDB [(none)]> grant all privileges on bacula.* to
> bacula@localhost; ERROR 1044 (42000): Access denied for user
> ''@'localhost' to database 'bacula'
>
> Apparently gets me nowhere.
>  

You need to be mysql/mariadb or system root to do that (or at least
identified as a user with "grant" privileges). Also, you don't appear
to have a database selected, hence the '[(none)]' on the prompt.
Note, the initial tables that you need to effect are mysql.user and
mysql.db. Look at the records for the bacula@% entries for templates
of what is needed. I would probably [mysql]dump the records from the
various mysql db tables, change the '%' to 'localhost' on the bacula
user ones, remove the other records (and create statements, if you
included them) and then load the resulting ones in.



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users