Today i upgraded MySQL to version 4.1 on FreeBSD Cpanel server (server28.hosthat.com)

With this version MySQL have some changes in the way it store user password. They doubled password storage space. To Upgrade MySQL on Cpanel Server, login to WHM as root.

Main >> Server Configuration >> Tweak Settings

Select MySQL 4.1 in the page.

After doing this, you have to upgrade MySQL through SSH, this can be done with command

/scripts/mysqlup

After doing this, lets upgrade Perl DBD::mysql module to work with new MySQL version. This can be done with

/scripts/perlinstaller –force Bundle::DBD::mysql

Now upgrade Apache with

/scripts/easyapache

MySQL Not Working After Upgrade

After the upgrade is over, i checked mysql is working with mysql command on command prompt. I got error, so check the MySQL start up script at

/usr/local/etc/rc.d/mysql-server.sh

On checking this file, it says i need to add following line to /etc/rc.conf

mysql_enable=”YES”

I have added this line and restarted the server. Server reboot is needed as mysql_enable=”YES” in /etc/rc.conf is used to set a variable, this is only set on boot time.

After reboot, MySQL start working fine.

In FreeBSD MySQL can be start with the init script

/usr/local/etc/rc.d/mysql-server.sh stop
/usr/local/etc/rc.d/mysql-server.sh start