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 version

Discussion in 'General Discussion' started by dxer, Apr 5, 2006.

  1. dxer

    dxer Well-Known Member

    Sep 9, 2002
    Likes Received:
    Trophy Points:
    I see here people talking about MySQL 4.1.x causing some problems with cPanel. I would like to know what MySQL version comes with cPanel 10.8.1-STABLE_114 and what exactly I must be careful for , when upgrading.

    If this latest cpanel stable has not integrate MySQL 4.1.x , then when can we expect this will be available ?

  2. OCX

    OCX Well-Known Member

    Sep 20, 2003
    Likes Received:
    Trophy Points:
    im using mysql 4.1x without issues..
    besure to check mark the box in WHM that says
    Use old style (4.0) passwords with mySQL 4.1 (required if you have problems with php apps authenticating)

    then run

    and change your mysql password if you get a error on restart

    easy enuff

    centos 4.x + cpanel latest
  3. celliott

    celliott Well-Known Member

    Jan 2, 2006
    Likes Received:
    Trophy Points:
    United Kingdom
    There were only real problems once support first came out. I would move into cPanel Current or Edge build to take advantage of the latest 4.1.18. Stable comes with 4.1.13 which is getting on a bit now.

    --Taken from my post in MySQL 4.1 Thread--

    I have now successfully updated our server to MySQL 4.1.18 and everything is running perfectly. For those of you who are still hesitatant to upgrade, I say just go for it. :)

    My method:

    In order to obtain the latest MySQL 4.1.18 through cPanel I just updated to the cPanel Current-112 version, no problems there, straightforward update.

    1. Create a backup of your current databases. I did this by backing up the /var/lib/mysql folder into a tar archive. Its advisable to stop MySQL first, to files in use can be read and databases cannot be changed whilst you upgrade.

    Do this using: tar -czf archivename.tar.gz /var/lib/mysql

    2. Go to WHM > Tweak Settings and tick MySQL 4.1. Click ok, wait 30sec and click the link as instructed. When thats completed open /etc/my.cnf with pico/nano and insert old-passwords under the mysqld tag. e.g.:


    Then Save, exit and restart MySQL.

    3. Recompile apache either with Apache Update in WHM or Easyapache, both do practically the same thing.

    4. Reinstall/update perl:

    tar zxf perl587installer.tar.gz
    cd perl587installer

    Once Perl had completed, I also ran /scripts/fixquotas to ensure that everything was set properly, and thats it!

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