I was playing a round with new software today which needed MySQL 5. My server’s running CentOS 4.6 which ships by default with MySQL 4.
The to upgrade to MySQL 5 from MySQL 4 is easy. There are 2 options you could use.
The first option would require you to remove all MySQL 4 packages by running,
># yum remove mysql
The seconf option is way simpler.
># yum --enablerepo=centosplus update mysql
This will download MySQL 5 from the plus repository and replace the installed MySQL 4.
Remeber to backup your DBs before updating.