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.
     
    #1 Kikloo, May 17, 2019
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,485
    Likes Received:
    187
    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...
    #2 GOT, May 17, 2019
  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.
     
    #3 Kikloo, May 17, 2019
  4. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,485
    Likes Received:
    187
    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...
    #4 GOT, May 17, 2019
  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.
     
    #5 Kikloo, May 17, 2019
  6. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,485
    Likes Received:
    187
    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...
    #6 GOT, May 17, 2019
  7. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,476
    Likes Received:
    507
    Trophy Points:
    263
    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...
    #7 cPanelLauren, May 17, 2019
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysql errors upgrading
  1. Netcrusher

    Backup with errors - roundcube mysqldump failed

    Netcrusher, Nov 19, 2018, in forum: Data Protection
    Replies:
    2
    Views:
    537
    Netcrusher
    Nov 26, 2018
  2. cPanelAlex

    SOLVED [Defect] MySQL Connection Failures and 500 Errors; CloudLinux + Imunify360

    cPanelAlex, Nov 15, 2018, in forum: General Discussion
    Replies:
    6
    Views:
    1,206
    cPanelLauren
    Nov 27, 2018
  3. ronaldst

    SOLVED MySQL errors - password and plugin authentication specified

    ronaldst, Nov 7, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    653
    cPanelLauren
    Nov 9, 2018
  4. maestroc

    sqlite and pdo_mysql errors after Apache 4 upgrade

    maestroc, Oct 3, 2018, in forum: EasyApache
    Replies:
    1
    Views:
    326
    cPanelLauren
    Oct 8, 2018
  5. cosmin

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    977
    cPanelMichael
    Jun 21, 2018

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.
    Accept Learn More...
    Dismiss Notice