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

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 Jurassic Moderator

August 22, 2023 07:31

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

August 22, 2023 11:32

What the name system backup that contain root database? backup system files checked

August 22, 2023 15:56

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

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

Comments

Didn't find what you were looking for?