On 2021-12-27 10:34, Graham Dicker wrote:
[...]
Thank you for the information.
mysql> select user, host from mysql.user;
returned the following (without the leading dots) :
. +-------------+-----------+
. | User        | Host      |
. +-------------+-----------+
. | bacula      | %         |
. |             | localhost |
. | mariadb.sys | localhost |
. | mysql       | localhost |
. | root        | localhost |
. |             | vivaldi   |
. +-------------+-----------+

I don't use passwords in my Bacula config files so I tried:
MariaDB [(none)]> GRANT ALL PRIVILEGES ON bacula.* TO 'bacula'@'localhost';
but it returned:
ERROR 1133 (28000): Can't find any matching row in the user table

That's because you don't have the row that looks like:
. +-------------+-----------+
. | User        | Host      |
. +-------------+-----------+
. | bacula      | localhost |

You have only:
- +-------------+-----------+
. | User        | Host      |
. +-------------+-----------+
. | bacula      | %         |

Which is nit the same thus the error "Can't find any matching
row in the user table".


Regards!

--
Josip Deanovic


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

Reply via email to