Can’t open and lock privilege tables: Table ./mysql/db is marked as crashed

On a Cpanel Server, MySQL did not start. I checked the error log in /var/lib/mysql folder, and found the following error in MySQL log file /var/log/mysqld.log

2023-03-10T18:13:26.405453Z 0 [ERROR] /usr/sbin/mysqld: Table './mysql/db' is marked as crashed and should be repaired
2023-03-10T18:13:26.405465Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/db' is marked as crashed and should be repaired
2023-03-10T18:13:26.405471Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2023-03-10T18:13:26.405486Z 0 [ERROR] Aborting

It says “db” table in “mysql” database got corrupted. To fix, I run following

cd /var/lib/mysql/mysql
myisamchk -r db

Now restart MySQL with the command

systemctl restart mysqld

Back to MySQL Repair

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *