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!

Remote MySQL not saving changes after update to MySQL 5.7

Discussion in 'Database Discussion' started by Wiseon3, Mar 16, 2019.

  1. Wiseon3

    Wiseon3 Registered

    Joined:
    Dec 5, 2012
    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hi,

    I've recently updated on CLoudlinux MySQL from 5.5 to 5.7 using mysqlgovernor script. The update did not give any errors, but I noticed that after the update if I try to remove a host in "Manage Access Hosts" I get the success message (e.g. "Removed Host “x.x.x.x” from the access list." but the host is still there.
    Same thing happens when trying to add, I get the success message but the host is not added. I tried recompiling Apache, I modified /etc/my.cnf to have:
    Code:
    sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    and restarted MySQL but the issue persists.

    Are there some logs I can check to find the issue?
     
  2. Wiseon3

    Wiseon3 Registered

    Joined:
    Dec 5, 2012
    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Issue was fixed after running as root
    Code:
    mysql_upgrade
     
    cPanelLauren likes this.
  3. 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
    Hello @Wiseon3

    Glad to hear you were able to resolve the issue and thanks for letting us know how it was resolved. It sounds like the mysql error logs would have probably indicated that mysql_upgrade needed to be run, I wouldn't necessarily recommend everyone run this without further information/investigation.
     
    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