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