Server Administration & Management

Downgrading MySQL5 to MySQL4.1 in cPanel

The default database version in cPanel server installs is MySQL5. If you want to downgrade your MySQL version 5 to 4.1, then here is following steps to downgrade the database (this should only be done on a new server without any account on it yet)

1. Log into SSH as root and modify the cpanel.config file

#vi /var/cpanel/cpanel.config

search for the mysql version

Ctrl + w , mysql

2. Now log into WHM and make sure MySQL 4.1 is checked in

Main >> Server Configuration >> Tweak Settings

And now change the version from 5.0 to 4.1, and now you need to run

#/scripts/mysqlup –force

to force the downgrade  mysql database.

January 22, 2011 Posted by | cPanel, MySQL | , , | 2 Comments