Issue Users absent from the database

[TIssi_2]

Server operating system version

Ubuntu 20.04

Plesk version and microupdate number

Plesk Obsidian 18.0.73

Hi! After migrating from ubuntu 18.04 to 20.04 I ran into two issues:

1) in the Repair Kit app there are problems with the MySQL- the user XX on the subscription XX.com is absent from the database server. All my users are absent from three different databases. If I try to repair it, I get this message: Recreating the user XX on the subscription XX.com SQLSTATE[HY000]: General error: 1396 Operation CREATE USERfailed for 'XX@'%'

2) Tools & Settings > System Updates: (I try to remember the message and translate it) your system's package manager database is showing some inconsistencies. You have to solve the problem manually,
For the time being the message is gone. I don´t have seen any note in the migration manual that such an error message might appear. What might be the problem and how can I solve it?

I also read this thread:
Resolved - Users suddenly absent from the database

Running the database search command I get this output:

[root@XX ~]# plesk db -Ne "select * from mysql.user;"
1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1
       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1       1

I am uncertain if I can use this procedure as well, since my MariaDB version is different. Any help is highly appreciated.

Repair Kit Version 1.4.3-6599
Plesk Obsidian 18.0.73
MariaDB 10.11.13

Best regards
Matthias

 

[scsa20]

Pretty sure that's a bug with MySQL/MariaDB. First create a backup of the database, then connect to the database and run FLUSH PRIVILEGES; and try repairing again. You might need to first drop the user, the flush the privileges, then recreate the users (basically do what what https://support.plesk.com/hc/en-us/...k-repair-utility-Operation-CREATE-USER-failed says).

Again, make a backup for the database first before doing anything else.

Worst comes to worst, open a ticket with Plesk directly (refer to https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk for info how) to get assistance at a more technical level where they can connect to your server with you and help you fix it.