On Monday, 27 December 2021 10:16:38 GMT Josip Deanovic wrote: > 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!
I tried (while running mysql as root) MariaDB [(none)]> UPDATE mysql.db SET Host='localhost' WHERE User='bacula'; that worked OK but this didn't MariaDB [(none)]> UPDATE mysql.user SET Host='localhost' WHERE User='bacula'; ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them I'm sure Bacula never used to involve this much mucking about! The configure and build process used to take care of all this didn't it? Graham
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
