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