Upgrading to MySQL 5.0.45 on RHEL and CentOS
As happens every 2 months or so, the community release of MySQL has been updated. The 5.0.45 release contains a substantial number of bug fixes since the last community release (5.0.41) but perhaps more interestingly, there were about 100 bug fixes since the last Enterprise release (5.0.44) just two weeks prior! This is definitely a release that I'd recommend all users of MySQL 5.0 upgrade to.
While MySQL does provide binary RPMs for RHEL & CentOS for their community releases, the binaries provided are not packaged in the same format as those that ship with RHEL, CentOS and Fedora. For those that want to stick with the "Red Hat"-style packages, add my yum repository to your system and run a "yum update".
For those that don't want to update other packages on their system (httpd, php, etc.), or for some reason feel like blowing a couple hours of free time, the src.rpm I used for building these packages is below. Just remember, your compile will fail if you try to build as 'root', so make sure that you've got a non-root build environment configured...
MySQL 5.0.45 Release Notes
Update (9/24/2009): Packages deleted, use the yum repository instead.