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.

How to install mysql that was previously removed?

Discussion in 'General Discussion' started by electric, Jul 12, 2016.

Tags:
  1. electric

    electric Well-Known Member

    Joined:
    Nov 5, 2001
    Messages:
    697
    Likes Received:
    1
    Trophy Points:
    18
    Hello,

    I am trying to update cpanel DNS-Only server to latest version, but I see this error:

    I think this means that mysql is maybe not installed? (I think must have been disabled/removed because it's a DNS-Only server and wasn't needed?)

    How can I check, and then re-install mysql if needed?

    Thanks!
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    To update, it looks like this issue was addressed through a support ticket by updating the target settings for the MySQL RPM to "installed", and running the check_cpanel_rpms script:

    Code:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
    /scripts/check_cpanel_rpms --fix
    Documentation on this script is available at:

    How to Set or Unset RPM Management

    Let us know if you have any additional questions.

    Thank you.
     
  3. electric

    electric Well-Known Member

    Joined:
    Nov 5, 2001
    Messages:
    697
    Likes Received:
    1
    Trophy Points:
    18
    Hello. That worked to fix the problem.

    However, will making this change result in MySQL *never* being updated by cpanel, even if DNS-Only update eventually upgrades to version 5.6 or higher, etc?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It's set to the "installed" state, so it's still managed as an RPM through cPanel. You would need to update the "mysql-version=" entry in /var/cpanel/cpanel.config to "mysql-version=5.6", and then run the following commands if you wanted to use MySQL 5.6:

    Code:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled
    /scripts/update_local_rpm_versions --edit target_settings.MySQL56 installed
    /scripts/check_cpanel_rpms --fix
    Thank you.
     
  5. electric

    electric Well-Known Member

    Joined:
    Nov 5, 2001
    Messages:
    697
    Likes Received:
    1
    Trophy Points:
    18
    Thanks!

    Will DNS-Only server eventually upgrade MySQL on its own once MySQL version 5.5 is dead? Or is there any way to tell cpanel DNS-Only that I want it to totally manage everything?

    Or will we need to eventually manually switch to v5.6 once v5.5 is eol?

    Lastly.. is there any reason *not* to switch to MySQL 5.6 right now? (Is it compatible with DNS-Only?)

    Thanks again.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    Typically, once a new version of cPanel no longer supports MySQL 5.5, when you go to update cPanel, a blocker message will notify you that you are unable to update to a new version of cPanel until you upgrade the version of MySQL on the system. It's acceptable to use MySQL 5.6 on cPanel DNS-Only.

    Thank you.
     
Loading...

Share This Page