I'll assume you have an 32-bit AMD chip. If you have an Opteron or other
64-bit AMD chip, you'd need to use the MySQL distribution labelled for
AMD64. Otherwise using the x86 distributions for Linux is fine.
You can find out specific information about your CPU on Linux by this
List of AMD 64-bit chips can be found here:
Here's my recommendation:
Linux (non RPM package) downloads:
Linux (x86) ... Max 5.0.18
The reason I don't favor using an RPM package on Redhat is that they have
created so many interdependencies between RPM packages on their Linux system
that it's virtually impossible to upgrade MySQL (or any single package)
through the RPM method. At least, I've never been able to do it.
The endorsed way to do it is to subscribe to the Redhat Network (which costs
$$$) and upgrade all packages simultaneously. I assume the RHN does not
offer MySQL 5 yet. But I cannot verify that, because there doesn't seem to
be any information about current offerings from rhn.redhat.com.
My solution would be to shut off the existing MySQL 3.23 daemon, install the
current version of MySQL 5.0 from a non-RPM distribution, and then enable
that. The RPM database will continue to believe it has MySQL 3.23
installed, and since MySQL is mostly backward-compatible, the other packages
that may use MySQL won't know the difference.
One significant exception regarding backward compatibility between MySQL
3.23 and 5.0 you should be aware of is documented here: