Upgrading MySQL to 5.6 on RHEL5
Backup all database.
mysqldump -uroot -p –all-database > 2014.sql mv /var/lib/mysql /var/lib/mysql.bak
Remove old mysql, mysql-server
yum list installed | grep -i mysql
yum remove mysql mysql-*
Download Yum Repository RPM Package
http://dev.mysql.com/downloads/repo/
Install RPM Package
rpm -ivh mysql-community-release-el5-5.noarch.rpm
Install mysql, mysql-server
yum install mysql mysql-server mysql-devel service mysqld start chkconfig mysqld on
Setting Password
mysqladmin -u root password
Import backup data
mysql -u root -p < ./2014.sql