Today i upgraded MySQL from version 4.0 to 4.1
[root@server10 root]# mysql –version
mysql Ver 12.22 Distrib 4.0.25, for pc-linux-gnu (i686)
[root@server10 root]#
mysql Ver 12.22 Distrib 4.0.25, for pc-linux-gnu (i686)
[root@server10 root]#
This is done as all other servers already using MySQL 4.1.
First have to set this on WHM, for this log in as root in WHM, then
Main >> Server Configuration >> Tweak Settings
Select MySQL 4.1 and save.
Now login to SSH as root and run
# /scripts/mysqlup
[root@server10 root]# /scripts/mysqlup
MySQL Setup Script Version 6.1
Fetching version information from http://updates.cpanel.net/mysqlinstall/version (RELEASE)….Done
This is the MySQL 4.1.14 installer release number 0 for platform
MySQL-shared is out of date (MySQL-shared-4.0.25-0 != MySQL-shared-4.1.14-0)
MySQL-devel is out of date (MySQL-devel-4.0.25-0 != MySQL-devel-4.1.14-0)
MySQL-embedded is out of date (MySQL-embedded-4.0.25-0 != MySQL-embedded-4.1.14-0)
MySQL-client is out of date (MySQL-client-4.0.25-0 != MySQL-client-4.1.14-0)
MySQL-bench is out of date (MySQL-bench-4.0.25-0 != MySQL-bench-4.1.14-0)
MySQL-server is out of date (MySQL-server-4.0.25-0 != MySQL-server-4.1.14-0)
MySQL-shared is out of date (MySQL-shared-4.0.25-0 != MySQL-shared-4.1.14-0)
Gathering header information file(s) from server(s)
MySQL Setup Script Version 6.1
Fetching version information from http://updates.cpanel.net/mysqlinstall/version (RELEASE)….Done
This is the MySQL 4.1.14 installer release number 0 for platform
MySQL-shared is out of date (MySQL-shared-4.0.25-0 != MySQL-shared-4.1.14-0)
MySQL-devel is out of date (MySQL-devel-4.0.25-0 != MySQL-devel-4.1.14-0)
MySQL-embedded is out of date (MySQL-embedded-4.0.25-0 != MySQL-embedded-4.1.14-0)
MySQL-client is out of date (MySQL-client-4.0.25-0 != MySQL-client-4.1.14-0)
MySQL-bench is out of date (MySQL-bench-4.0.25-0 != MySQL-bench-4.1.14-0)
MySQL-server is out of date (MySQL-server-4.0.25-0 != MySQL-server-4.1.14-0)
MySQL-shared is out of date (MySQL-shared-4.0.25-0 != MySQL-shared-4.1.14-0)
Gathering header information file(s) from server(s)
Once this is completed, you have MySQL 4.1 installed.
[root@server10 root]# mysql –version
mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 4.3
[root@server10 root]#
mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 4.3
[root@server10 root]#
Now we have to upgrade perl modules, so that it will work with new MySQL version. This is done with
# /scripts/perlinstaller –force Bundle::DBD::mysql
Now we need to reinstall Apache/PHP, so that PHP will work with New MySQL version, this is done with
# /scripts/easyapache
MySQL 4.0 and 4.1 have some difference in the way passwords are stored. So if your cpanel server use MySQL 4.0 and try to connect to another server that run MySQL 4.1, you will get error saying MySQL client need to upgraded.
