check_mysql has determined that there are corrupted database tables

[NetProwler]

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]

Hello

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

Thank you.

 

[NetProwler]

Yes. There is no error. Only cPanel is sending these error messages and there is no other issue with Mysql.

 

[cPanelMichael]

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]

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]

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]

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]

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]

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]

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]

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.