The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

check_mysql has determined that there are corrupted database tables

Discussion in 'Database Discussions' started by NetProwler, Oct 26, 2015.

  1. NetProwler

    NetProwler Registered

    Joined:
    Nov 19, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    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.

     
    #1 NetProwler, Oct 26, 2015
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    34,936
    Likes Received:
    1,067
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

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

    Thank you.
     
    #2 cPanelMichael, Nov 11, 2015
  3. NetProwler

    NetProwler Registered

    Joined:
    Nov 19, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Yes. There is no error. Only cPanel is sending these error messages and there is no other issue with Mysql.
     
    #3 NetProwler, Nov 16, 2015
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    34,936
    Likes Received:
    1,067
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
    #4 cPanelMichael, Nov 16, 2015
  5. chrisweb

    chrisweb Member

    Joined:
    Nov 18, 2014
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hello, we have the same email error message since update to version 11.52.1.2.
    The concerned database are:
    • cphulkd
    • leechprotect
    • munin_innodb
    • mysql
    • eximstats
    • modsec
    • roundcube
    • whmxfer
    We have try the recommandation to repair the tables with "Repair a MySQL Database" page, got all "ok" status and the error still report the day after.

    The "mysql" database was not in the list of the repair database page.

    Any update on this?

    Thank you
     
    #5 chrisweb, Nov 19, 2015
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    34,936
    Likes Received:
    1,067
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
    #6 cPanelMichael, Nov 19, 2015
  7. chrisweb

    chrisweb Member

    Joined:
    Nov 18, 2014
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hello cPanelMichael, thank you for the fast reply, your answer totally makes sense.
    I will look for the changelog to see when it is implemented.

    Thank you again, have a nice day!
     
    #7 chrisweb, Nov 20, 2015
  8. harleyb

    harleyb Registered

    Joined:
    Feb 4, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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
     
    #8 harleyb, Nov 20, 2015
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    34,936
    Likes Received:
    1,067
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It's only related to this case if a server has a non-root user with UID 0.

    Thank you.
     
    #9 cPanelMichael, Nov 23, 2015
  10. harleyb

    harleyb Registered

    Joined:
    Feb 4, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
    #10 harleyb, Nov 23, 2015
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    34,936
    Likes Received:
    1,067
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you let us know the full error messages you are receiving?

    Thank you.
     
    #11 cPanelMichael, Dec 10, 2015
  12. harleyb

    harleyb Registered

    Joined:
    Feb 4, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Still getting these 2x a day. Thanks for your help.

     
    #12 harleyb, Dec 11, 2015
  13. chrisweb

    chrisweb Member

    Joined:
    Nov 18, 2014
    Messages:
    21
    Likes Received:
    2
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    It's been solved on our side with cPanel update to version 11.52.2.1 on 2016-01-06.

    What about you guys?
     
    #13 chrisweb, Jan 14, 2016
  14. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    34,936
    Likes Received:
    1,067
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you verify if the issue persists on cPanel version 54? It's currently available in the release build tier.

    Thank you.
     
    #14 cPanelMichael, Feb 2, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - check_mysql determined corrupted
  1. Niel Sagaert

    check_mysql has determined that there are corrupted database tables

    Niel Sagaert, Apr 11, 2016, in forum: General Discussion
    Replies:
    1
    Views:
    494
    cPanelMichael
    Apr 12, 2016
  2. calamus

    check_mysql has determined that there are corrupted database tables

    calamus, Apr 11, 2016, in forum: Database Discussions
    Replies:
    7
    Views:
    2,514
    cPanelMichael
    Apr 14, 2016
  3. Creative Visual

    check_mysql has determined that there are corrupted database tables

    Creative Visual, Sep 21, 2015, in forum: Database Discussions
    Replies:
    3
    Views:
    608
    cPanelMichael
    Sep 21, 2015
  4. Gianpiero Colagiacomo

    check_mysql has determined that there are corrupted database tables

    Gianpiero Colagiacomo, Aug 10, 2015, in forum: Database Discussions
    Replies:
    1
    Views:
    833
    cPanelMichael
    Aug 24, 2015
  5. John Fotios

    cPanel & WHM has determined that the following database tables are corrupt

    John Fotios, Jun 23, 2016, in forum: Database Discussions
    Replies:
    3
    Views:
    506
    Infopro
    Jun 23, 2016

Share This Page