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

Reply via email to