The system failed to drop the MySQL user error

[udee]

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

 

[24x7server]

Hi,

Try repairing the MySQL tables:
#mysqlcheck -r mysql
Check what error you get when it checks the table.

 

[cPanelMichael]

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.