Upgrade MySQL 5.5 to 5.6 on EC2/CentOS/RHEL
You would like to upgrade MySQL 5.5 to MySQL 5.6 on an existing server that uses the YUM software package manager.
Just enter the following few simple commands and you should be good to go. But, please, do a thorough full backup of your system before you do the upgrade just in case.
 Create a MySQL dump from which you will load the data into the upgraded server:
mysqldump -u root -p --add-drop-table --routines --events --all-databases --force > data-for-upgrade.sql
 Stop your MySQL server
sudo service mysqld stop
 Remove MySQL 5.5
yum remove mysql55-server mysql55-libs mysql55-devel mysql55-bench mysql55
 Clear the MySQL data directory
sudo rm -r /var/lib/mysql/*
 Install MySQL 5.6
sudo yum install mysql56 mysql56-devel mysql56-server mysql56-libs
 Start MySQL server
sudo service mysqld start
 Set the root password
/usr/libexec/mysql56/mysqladmin -u root password 'xxx'
 Import your data
mysql -u root -p --force < data-for-upgrade.sql
 Verify all tables will work in 5.6
sudo mysql_upgrade -u root -p --force
- Upgrade to 5.7 should work in a similar way, once 5.7 is available on your RPM repos (it isn't by the time of the writing for the Amazon Linux Repo).