check_mysql has determined that there are corrupted database tables

NetProwler

Registered
Nov 19, 2013
2
0
1
cPanel Access Level
Root Administrator
Of late I am getting these mails from Cpanel of my dedicated server.

cPanel & WHM has determined that the following database tables are corrupt:
mysql /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

I have created a new MySql Profile from home->Sql services -> Manage Mysql profiles
and activated the current profile and still I am getting these messages. What do I miss here?

I would be grateful for any pointers.
Other than these messages, the Mysql database is working normally.

 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,245
463
Hello :)

Are you able to run the "mysql" command from the cPanel server without error?

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,245
463
Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,245
463
Hello :)

The original poster's issue relates to internal case CPANEL-2150:

If a server has a non-root user with UID 0, and that user's home directory is not /root, it breaks check_mysql, because the script runs as root and cannot read /root/.my.cnf, with default 700 permissions on /root and .my.cnf.

You can monitor our change log for this case number to see when it's been implemented with cPanel. Note that you should open a separate thread if your issue is unrelated.

Thank you.
 

harleyb

Registered
Feb 4, 2009
3
0
51
Hi there,

I just started getting these emails daily, with the exact same error ("/usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect"). I have no problem running mysql as root with no password normally. However, root *is* UID 0, so I'm not sure if it falls under CPANEL-2150. Please advise. WHM 11.52.0.24

Cheers,
-Harley
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,245
463
However, root *is* UID 0, so I'm not sure if it falls under CPANEL-2150.
It's only related to this case if a server has a non-root user with UID 0.

Thank you.
 

harleyb

Registered
Feb 4, 2009
3
0
51
It's only related to this case if a server has a non-root user with UID 0.
Yes, but it's still the same problem that the original thread poster has, as far as I can tell. Should I post a new thread then? I'm still getting two of these messages every day.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,245
463
Yes, but it's still the same problem that the original thread poster has, as far as I can tell.
Could you let us know the full error messages you are receiving?

Thank you.
 

harleyb

Registered
Feb 4, 2009
3
0
51
Could you let us know the full error messages you are receiving?

Thank you.
Still getting these 2x a day. Thanks for your help.

check_mysql has determined that there are corrupted database tables
cPanel & WHM has determined that the following database tables are corrupt:

Database Error
cphulkd /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
leechprotect /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
horde /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
mysql /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
eximstats /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
modsec /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
roundcube /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
whmxfer /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
We recommend that you repair these tables with WHM’s “Repair a MySQL Database” interface (WHM Home » SQL Services » Repair a MySQL Database). If the repair fails, contact cPanel Support for further assistance.

This notice is the result of a request from “check_mysql”.
This notice was generated “Thursday, December 10, 2015 10:05:08 AM UTC”.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,245
463
Still getting these 2x a day. Thanks for your help.
Could you verify if the issue persists on cPanel version 54? It's currently available in the release build tier.

Thank you.