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 <epodata AT gmail DOT com>:
> 
> > On 2017-03-13 at 13:38:44 Richard wrote:
> >  
> > > > Date: Monday, March 13, 2017 14:07:04 +0100
> > > > From: "Erik P. Olsen" <epodata AT gmail DOT 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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users