29 Apr

Upgrading MySQL 4 to MySQL 5

Posted by Jacob, under Server Administration

Login to WHM as root and go to tweak settings. Under the Myql Section click version 5.0. Login to the server through shell and run

/scripts/mysqlup

Once this is completed, make sure mysql 5 has started, run

mysql

If it fails to connect run

/etc/init.d/mysql start

If it fails to start edit the /etc/my.cnf and commend out the line Basedir=/var/lib/mysql and then start mysql

Once you have mysql 5 fully started you must recompiled php to work with the new mysql errors. You can either do this from source or from easyapache whichever you are more comfortable with. If you choose easyapache make sure you select option #7 from the easy apache menu and you do not need to make any changes.

  • Digg
  • del.icio.us
  • Facebook
  • Reddit
  • Slashdot
  • Twitter
Tags:
One Response to “Upgrading MySQL 4 to MySQL 5”
Peter Posted on May 4, 2010 at 7:58 pm

Also, depending on the version you are wanting, such as mysql 5.1 or 5.2 you can set that in the cpanel config file in /var/cpanel/cpanel.config. The line is mysql-version= You can put 5.1 or 5.2, depending on the version you are wanting to use then recompile.

Post a Comment