I was having some issues with slow data retrieval under MySQL 4.1.22 after running up2date (in JAN 09), and did a search here on The Planet. No luck on finding a post, so did some additional searching and found one on Parallels site, but the information for compatability pack was incorrect. Here is the corrected version, for those wishing to upgrade to MySQL 5. Somewhat dated, but there might be others like me who are just getting around to updating their box.

Logon to your server, get into root account.

cd /home
mkdir /mysql5
cd /mysql5

Main files found at: http://downloads.mysql.com/archives.php?p=....0&v=5.0.18

wget http://downloads.mysql.com/archives/mysql-....rhel4.i386.rpm
wget http://downloads.mysql.com/archives/mysql-....rhel4.i386.rpm
wget http://downloads.mysql.com/archives/mysql-....rhel4.i386.rpm
wget http://downloads.mysql.com/archives/mysql-....rhel4.i386.rpm

Compatability files found at: http://rpm.pbone.net/index.php3/stat/4/idp...1.i386.rpm.html (per Parallels / Ensim forum post above)

wget ftp://ftp.pbone.net/mirror/ftp.centos.org...l4s1.1.i386.rpm

Now for install procedure:

/etc/rc.d/init.d/service mysqld stop
rpm -Uvh *.rpm

After install completes:

ln -s /etc/init.d/mysqld_app_init /etc/init.d/mysqld

You will need to ADD some data to a file, I use pico, but there are other text editors out there as well.

pico -w /etc/virtualhosting/filelists/siteinfo.sh

ADD the following at top of file where similar data is show, about 30 lines down:

# added for MySQL5.0.18 install
N:S,rpm:MySQL-shared-standard
N:S,rpm:MySQL-client-standard
N:S,rpm:MySQL-devel-standard
N:S,rpm:MySQL-server-standard
N:S,rpm:mysqlclinet14

Save then exit text editor

You will need to run the server through maintenance mode:

/etc/local/sbin/synchronizeFST -S

Then restart mysqld:

/etc/rc.d/init.d/mysqld start

You should now access your MySQL db via the Ensim control panel, or via MyAdmin, to validate install of 5.0.18.