Symptoms
MySQL/MariaDB is down and is unable to be started.
Description
Due to space issues or if a server is powered off/halted, a database table may be in a corrupted state. In a situation where the mysql database has a corrupt table like mysql.user MySQL will not start due to corruption. That error seen would be the following depending on the table:
[Server] Table './mysql/user' is marked as crashed and should be repaired
Workaround
Typically you can repair user databases while MySQL/MariaDB is running using "Home » SQL Services » Repair a MySQL® Database" in WHM. In this situation, the MySQL service isn't running, and the table needs to be repaired manually.
1) Confirm the table is corrupt by running the following:
myisamchk -s /var/lib/mysql/mysql/user
2) If the table is corrupted, it can be repaired using the following command:
myisamchk -r --update-state /var/lib/mysql/mysql/user
Please note that cPanel, LLC only supports the cPanel-provided software and does not provide general system-administration services. You may, therefore, wish to seek assistance from a qualified server/systems administrator to perform these tasks.