On Monday, 27 December 2021 19:47:40 GMT Josip Deanovic wrote: > On 2021-12-27 19:38, Graham Dicker wrote: > > 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' > > Did you use drop user or did you manually remove user from > the user table in the mysql database? > > If you manually deleted user from the mysql database, you > need to issue the command: flush privileges;
I used drop user. This morning I did the flush privileges command and tried the create user again. It worked this time and Bacula runs OK. Only snag is that this incarnation of bacula can't use the database created by the previous bacula. Never mind. I will try making a backup and if I have to new volumes so be it. Graham _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
