On 2017-03-13 at 11:46:52 Wanderlei Huttel wrote: Hello Wanderlei, [root@Erik-PC bacula]# ./grant_mysql_privileges -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Error creating privileges. [root@Erik-PC bacula]#
-- Erik > Hello Erik > > Run the command informing user and password (just -p) then the prompt > will ask for your password. > ./grant_mysql_privileges -u root -p > > > Best regards > > *Wanderlei Hüttel* > http://www.huttel.com.br > > 2017-03-13 11:34 GMT-03:00 Erik P. Olsen <epod...@gmail.com>: > > > On 2017-03-13 at 13:38:44 Richard wrote: > > > > > > Date: Monday, March 13, 2017 14:07:04 +0100 > > > > From: "Erik P. Olsen" <epod...@gmail.com> > > > > > > > > On 2017-03-13 at 12:40:52 Richard wrote: > > > > > > > > > > ... > > > > > > >> > > > >> If it shows a list of the ~25+ tables (likely ending with > > > >> "Version"), then exit mysql/mariadb and (still as system root) > > > >> run the "grant_mysql_privileges" script that's in your > > > >> /usr/libexec/bacula/ directory. > > > > > > > > Yes, I see 26 rows ending with Version. > > > > > > > >> > > > >> After doing that, then as a normal (non-root) system user, do: > > > >> > > > >> mysql -u bacula > > > >> > > > >> [i don't believe that a password is set, but you can look at > > > >> the top of the grant script to confirm this.] > > > >> > > > >> show databases; > > > > > > > > Unfortunately does not show "bacula". > > > > > > > > > > > > > When you ran the "grant_mysql_privileges" script did it give a > > > multi-column display of settings, with something like "Privileges > > > for user ..." at the bottom? If so, could you confirm the user/db > > > information on that line (you can rerun the script without having > > > to take any other actions). If not, what type of output (if any) > > > did you get? > > > > These are the first few lines: > > > > [root@Erik-PC bacula]# ./grant_mysql_privileges > > Created MySQL database user: bacula > > ERROR 1133 (28000) at line 2: Can't find any matching row in the > > user table Host User Password Select_priv > > Insert_priv Update_priv Delete_priv > > Create_priv Drop_priv Reload_priv Shutdown_priv > > > > And this is the last: > > > > Privileges for user bacula granted on database bacula. > > > > -- > > Erik > > > > > > > > > > ------------------------------------------------------------ > > ------------------ > > 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 > > ------------------------------------------------------------------------------ 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
