On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote: > On 12/27/21 12:10, Josip Deanovic wrote: > > On 2021-12-27 14:24, Graham Dicker wrote: > >> I can't get those commands to work > >> > >> MariaDB [mysql]> CREATE USER 'bacula'@'localhost' IDENTIFIED BY 'xxx'; > >> ERROR 1396 (HY000): Operation CREATE USER failed for > >> 'bacula'@'localhost' > >> MariaDB [mysql]> UPDATE mysql.user SET Host='localhost' WHERE > >> User='bacula'; > >> ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or > >> column(s) > > The blazes....? If mysql.user is a VIEW, something is VERY BADLY WRONG. > > Are you still using Akonadi's MySQL instance?
Not as far as I can tell. I changed /etc/my.cnf to say: port = 3306 I realized (eventually) that I couldn't create another user bacula without dropping the existing one first. So I dropped user bacula but now I can't create it again. create user 'bacula2'@'localhost'; works but create user 'bacula'@'localhost'; results in ERROR 1396 (HY000): Operation CREATE USER failed for 'bacula'@'localhost' Graham
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users