I've sucessfully installed MySQL 4 a number of times. I'll go through all of my notes and write up a nice How-To shortly. In the mean time, here are the basic steps:
- stop MySQL and remove the exisiting rpms (rpm -e)
- download the MySQL 4 rpms from mysql.com (don't use Red Hat's rpms), make sure the use the libraries which are compatible with MySQL 3 & 4.
- install the rpms (use rpm -Uvh)
- do the following to handle startup:
chkconfig --levels 2345 mysql on
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysql /etc/rc.d/rc7.d/S90mysqld
Note: the chkconfig step was necessary with MySQL 4.0.13 and eartlier. I believe more recent MySQL rpms have fixed the bug which required this. Go back through this thread for some more details.
Noah