Oops I should have replied to my own message. And the leading pipe symbols 
seem to cause a problem. Sorry about that.

MariaDB [mysql]> select host,user from user;
+-----------+-------------+
 Host      | User        |
+-----------+-------------+
 %         | bacula      |
 localhost |             |
 localhost | mariadb.sys |
 localhost | mysql       |
 localhost | root        |
 vivaldi   |             |
+-----------+-------------+
6 rows in set (0.001 sec)


On Thursday, 23 December 2021 14:42:12 GMT Graham Dicker wrote:
> Hi all
> 
> I'm running Bacula on a desk machine with OpenSuse 15.3 and Bacula 11.0.4.
> 
> The make_catalog_backup command has stopped working following a complete
> loss and restore of my Bacula database.
> I don't know how the database vanished but I restored it from the last
> successful backup thus:
> 
> ./bextract -b ../working/BackupCatalog.bsr /media/seagate4tb /tmp
> mysql
> create database bacula;
> use bacula;
> source bacula.sql;
> grant_mysql_privileges
> 
> But now although my main backup works fine the backup of the catalog gets
> this error:
> 
> 23-Dec 13:39 vivaldi-dir JobId 65: BeforeJob: mysqldump: Got error: 1044:
> "Access denied for user ''@'localhost' to database 'bacula'" when selecting
> the database
> 
> Any clues? Thanks in advance.






_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to