MySQL 5

Just installed MySQL 5 on my Fedora Core 3 box. The process was very smooth, compared to my previous experience with upgrading MySQL from the 3.xx to 4.xx.

Here it is what I did, in details:

1. Download all the required RPM from mysql.com. There's actually no specific RPMs for the Fedora Core 3(FC3), but I've read somewhere that FC3 is the same product as the Redhat Advanced Linux 4(RHEL4). So I decided to give it a try, and download the packages for RHEL 4.
2. Uninstall the mysql related packages from FC3.
3. Cross my finger and run rpm -Uvh MySQL-* and everything worked as a charmed. The softwares fall into the intended places.:D Red Hat don't lie when they said FC has the same code base as the RHEL.
   
4. Do the all the ussual tests. Hm... looks OK. Just notice that there's a new "system" database. Don't remember the name. The tables on database mysql, also get new columns.Does it mean better security?
   
5. Run the web based application to find out I nuked the php-mysql package. Try to install it, but it complains about incorrect mysql version.
   
6. Download the php source rpm for the RHEL 4 from redhat.com ftp site, and rebuild it using rpmbuild --rebuild. The install was a success. The web based application is up and running.

Hm... can't wait to play with it. With all the new features: trigger, views, stored-procedures, the MySQL 5 would be a good toy for me. :D