recently had the need to upgrade from mysql 3.23 to a specific version of mysql on an FC3 box
wanted to share the steps taken...

- locate rpm mirror and download rpms
- backup data and all mysql config
- stop mysql / httpd
- remove old version of mysql
- install rpms

* some versions of mysql may encounter problems in changing ownership to mysql,
mine did, so i had to manually chown certain files:

chown mysql:mysql /var/run/mysqld
chown mysql:mysql /var/lib/mysql


the complete list of commands can be found here too:
http://inn3rflow.blogspot.com/2007/02/upgr...ql-5027-on.html

hope this helps someone