Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Mysql errors after upgrading to 5.7

Discussion in 'Database Discussion' started by Kikloo, May 17, 2019.

  1. Kikloo

    Kikloo Member

    Joined:
    Mar 31, 2017
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    I am constantly getting errors after upgrading to mysql 5.7. I was hesitant that after the upgrade I will end up with errors and my nightmares became true. I upgraded and now whenever I try to goto mysql in cpanel I get the following:

    ---
    The MySQL server is currently offline.
    Error while connecting to MySQL: (XID ezmaex) The system failed to connect to the “MySQL” database “mysql” because of an error: ER_ACCESS_DENIED_ERROR (Access denied for user 'root'@'localhost' (using password: YES)) Error while connecting to MySQL: (XID ezmaex) The system failed to connect to the “MySQL” database “mysql” because of an error: ER_ACCESS_DENIED_ERROR (Access denied for user 'root'@'localhost' (using password: YES)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 397, <STDIN> line 1.
    ---

    mysql is up and running and sites are also working, only that when I try to access mysql in cpanel I get the above.

    When I try to run "mysql" in ssh i get another error:

    ---
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    ---

    What is happening ? How do I fix this ????

    Please help.

    Thanks.
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,370
    Likes Received:
    154
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Go to MySQL Root Password in WHM and set a new password for root. This should resolve your error.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Kikloo

    Kikloo Member

    Joined:
    Mar 31, 2017
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    I have already done that 2-3 times already but its not working.

    Thanks.
     
  4. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,370
    Likes Received:
    154
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    If that does not work, then you've got something very strange going on that we would not be able to tell without mor info as you really just need to start digging around.

    Does phpmyadmin load from WHM (Probably not)?

    You might want to log in the error log for mysql in /var/lib/mysql and see if there are any clues in there. Perhaps the mysql database is corrupted.

    You could also try bypassing cPanel and just forcing a root password change manually. Info here:

    Reset a MySQL root password

    These are generic instructions so may need to be interpreted a little for cPanel.

    Once you set a working mysql passowrd you may want to try running a repair on at least the mysql database if not all databases.

    You also may want to run mysql_upgrade once you have a working passowrd because if the upgrade process could not connect like you cannot connect then that may not have been run yet.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Kikloo

    Kikloo Member

    Joined:
    Mar 31, 2017
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    hi,

    phpMyadmin from WHM is loading.
    I have also set the mysql password.

    But in WHM > Service Status : mysql is showing as down, where as all the websites etc. are working with mysql.

    I am not sure what is really going on.

    This is so much weird.

    Please help.

    Thanks.
     
  6. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,370
    Likes Received:
    154
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Solving this is probably going to take a seasoned administrator since the obvious and normal fixes are not working. You may want to consider putting a ticket in with cPanel so they can log in and look.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,815
    Likes Received:
    443
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    I think this definitely needs a ticket, can you please open one using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved.


    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice