> Date: Thursday, March 16, 2017 13:04:24 +0100 > From: "Erik P. Olsen" <epod...@gmail.com> > > On 2017-03-16 at 11:10:10 Richard wrote: > >> > Date: Thursday, March 16, 2017 08:00:26 +0100 >> > From: "Erik P. Olsen" <epod...@gmail.com> >> > >> > On 2017-03-15 at 21:17:07 Dan Langille wrote: >> > >> >> > On Mar 14, 2017, at 2:42 AM, Erik P. Olsen <epod...@gmail.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users