Table is crashed and last repair failed"' for './mysql/global_priv'

[Naila]

I have a problem with the mariaDB database on my server. The problem that I experienced was that all database usernames lost access, including root. This issue occurs when the power goes out and the server shuts down unexpectedly.

The first problem that is visible in the mysql err log is

[ERROR] Table is crashed and last repair failed"' for './mysql/global_priv'
[Warning] Access denied for user 'root'@'localhost' (using password: YES)
[Warning] Access denied for user 'usercpanel1'@'localhost' to database 'cccc'
[Warning] Access denied for user 'usercpanel2'@'localhost' to database 'bbbb'
[Warning] Access denied for user 'usercpanel3'@'localhost' to database 'aaaa'

Next I noticed this issue after adding the skip-grant-tables line in my.cnf to force mysql start, because previously mysql wont start. After some time I also saw this err log

[ERROR] mariadbd: Got error '144 "Table is crashed and last repair failed"' for './mysql/proc'


If I remove skip-grant-tables from my.cnf, access to database will fail on all websites.


10.6.14-MariaDB
Whm 112.0.5

I hope someone can help me

 

[cPRex]

Hey there! The easiest solution would be to restore the "mysql" table itself from a recent backup, since it seems the system tables itself have crashed. Do you have a backup of the databases on the machine?

 

[Naila]

What the name system backup that contain root database?

backup system files checked

 

[cPRex]

Yes, if the system files are backed up you should have those available to restore. We have additional details on performing this work here:

https://support.cpanel.net/hc/en-us/articles/360055635974-How-to-restore-the-Entire-MySQL-Directory-from-cPanel-system-backups

but if you're not comfortable with that you may need to work with a system administrator to get that working.