HostOnNet Blog

Upgrading MySQL 4 to 4.1 in FreeBSD Cpanel Server.

Looking for Linux Server Admin or WordPress Expert? We can help.

Today i upgraded MySQL to version 4.1 on FreeBSD Cpanel server (

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


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


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


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


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/ stop
/usr/local/etc/rc.d/ start

Posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.