Please test on a fresh install, because it is likely to destroy some settings and data! Perhaps someone can refine it to not kill webmail!
1 # mysql
logs in as version 4.1.12
2 mysql> quit;
3 # /etc/rc.d/init.d/supervise/mysqld status
/service/mysqld: run (pid 29128) 53510 seconds, normally down
4 # /etc/rc.d/init.d/supervise/mysqld stop
Stopping mysqld: [ OK ]
5 # /etc/rc.d/init.d/supervise/mysqld status
/service/mysqld: down 6 seconds
6 # rpm -e mysql-server --nodeps
7 # rpm -e mysql --nodeps
8 Download
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-5.0.18-1.c4.i386.rpmhttp://dev.centos.org/centos/4/testing/i386/RPMS/mysql-server-5.0.18-1.c4.i386.rpmDo NOT get the versions with 5.0.18-2.1, they fail dependecies!
9 # rpm -Uvh mysql-5.0.18-1.c4.i386.rpm
10 # rpm -Uvh mysql-server-5.0.18-1.c4.i386.rpm
11 # mysql ( see what happens )
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18
13 reboot
14 # mysql ( make sure it restarted automatically! )
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18
15 Check Web Mail
A fatal error has occurred
DB Error: insufficient permissions
Details have been logged for the administrator.
16 Reset per Charly Brady , destroys data!!
# cd /service/mysqld
# runsvctrl d .
# /etc/e-smith/events/actions/mysql-delete-db-files
# signal-event post-upgrade
# signal event reboot
15 Check Web Mail
GOT LOGIN!!!