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