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;
--
Josip Deanovic
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users