check_mysql has determined that there are corrupted database tables

NetProwler

• October 26, 2015 02:22

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. [LIST]

• 

  cPanelMichael

  • November 11, 2015 19:27

  Hello :) Are you able to run the "mysql" command from the cPanel server without error? Thank you.

  0
• 

  NetProwler

  • November 16, 2015 07:08

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

  0
• 

  cPanelMichael

  • November 16, 2015 13:32

  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.

  0
• 

  cPanelMichael

  • November 19, 2015 16:53

  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

  0
• 

  harleyb

  • November 20, 2015 14:46

  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

  0
• 

  cPanelMichael

  • November 23, 2015 15:12

  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.

  0
• 

  harleyb

  • November 23, 2015 15:22

  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.

  0
• 

  cPanelMichael

  • December 10, 2015 16:55

  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.

  0
• 

  harleyb

  • December 11, 2015 14:09

  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".
  

  0
• 

  cPanelMichael

  • February 02, 2016 21:45

  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.

  0

Please sign in to leave a comment.