> On Mar 14, 2017, at 2:42 AM, Erik P. Olsen <[email protected]> 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 [email protected] ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
