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.

Changed tweak settings from MySQL 4.1 to 5, need to revert

Discussion in 'General Discussion' started by tomfra, Nov 5, 2008.

  1. tomfra

    tomfra Well-Known Member

    Joined:
    Sep 30, 2002
    Messages:
    62
    Likes Received:
    0
    Trophy Points:
    6
    I've just changed the settings in the WHM -> Twek Settings from MySQL 4.1 to MySQL 5. I haven't run the /scripts/mysqlup script yet so it is not in effect yet. However, the option to switch back to 4.1 is not displayed any longer.

    Since the change did not actually take place yet, I suppose there should be a way to revert it, right?

    Tomas
     
  2. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    If you are 100% sure the change has not taken place you can edit /var/cpanel/cpanel.config manually and change the mysqlversion key
     
  3. tomfra

    tomfra Well-Known Member

    Joined:
    Sep 30, 2002
    Messages:
    62
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for the prompt reply!

    In the end it was, fortunately, not necessary to stay with MySQL 4.1 so I moved forward with the MySQL 5 version and it's working OK so far.

    Tomas
     
  4. carluk

    carluk Well-Known Member

    Joined:
    Sep 2, 2003
    Messages:
    162
    Likes Received:
    0
    Trophy Points:
    16
    Doesn't it run /scripts/mysqlup in the background once you've made the change? I recall last time I made that change it did.
     
  5. chuza

    chuza Well-Known Member

    Joined:
    Jul 4, 2008
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    I believe it doesn't. run /scripts/mysqlup --force
     
  6. carluk

    carluk Well-Known Member

    Joined:
    Sep 2, 2003
    Messages:
    162
    Likes Received:
    0
    Trophy Points:
    16
    What does that have to do with anything?
     
  7. chuza

    chuza Well-Known Member

    Joined:
    Jul 4, 2008
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    You wanted to downgrade MySQL. Once you change MySQL version in cpanel.config file, it will not automatically run mysqlup, so I told you to run /scripts/mysqlup --force for forceful downgrade.
     
  8. carluk

    carluk Well-Known Member

    Joined:
    Sep 2, 2003
    Messages:
    162
    Likes Received:
    0
    Trophy Points:
    16
    Sorry for not being clear, I mean with regards to:
     
  9. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    When you change this setting, you are essentially only changing the setting stored in cpanel.config. As downgrading is not advised, the option to use an older version of MySQL than the one specified in cpanel.config is hidden.

    Editing cpanel.config directly would have the same affect as changing the tweak setting (if 4.1 was shown - which it would not be in this scenario since 5 was already selected). If you are absolutely certain you are still running 4.1, modifying cpanel.config to reflect this should not cause issues. However, do double-check this before changing this manually in cpanel.config.
     
  10. jackal

    jackal Well-Known Member
    PartnerNOC

    Joined:
    Feb 23, 2002
    Messages:
    708
    Likes Received:
    0
    Trophy Points:
    16
    How to set mysql 4.1.22 on a new install, new install now installs mysql 5, but need mysql 4.1.22 on the new install. How to make this happen?

    Joey
     
  11. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Correct, MySQL 5 is our default for new cPanel/WHM installations. Feel welcome to submit a support ticket if you desire to use an older version of MySQL.
     
  12. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    18
    I have a server left that still runs MySQL 4.0.27 and was wondering if CPanel 11.24 is compatible with MySQL 4.0.27. (I know it's an older version)
     
  13. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Yes cPanel 11.24 is compatible with MySQL 4.0.
     
Loading...

Share This Page