The system failed to drop the MySQL user error

udee

Registered
Jul 14, 2018
1
0
1
indonesia
cPanel Access Level
DataCenter Provider
hi,

after i downgrade from mariadb 10.2 to mysql 5.6
i got this error when i delete user
The system failed to drop the MySQL user “xxxx” because of an error: (XID bn962q) The system received an error from the “MySQL” database “mysql”: 1728 (Cannot load from mysql.procs_priv. The table is probably corrupted)

and the db user that should be deleted is still exist in database mysql.user but not visible by cpanel user from web
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
Hello @udee,

There's no supported path to downgrade from MariaDB to MySQL on cPanel & WHM. Can you let us know the full steps you took to downgrade?

Thank you.