> 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.
-- 
Dan Langille - BSDCan / PGCon
dan AT langille DOT org



------------------------------------------------------------------------------
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