Upgrading mysql version 5.7

Beginning with MySQL 5.7.8, MySQL supports a native JSON type. JSON values are not stored as strings, instead using an internal binary format that permits quick read access to document elements. JSON documents stored in JSON columns are automatically validated whenever they are inserted or updated, with an invalid document producing an error. JSON documents are normalized on creation, and can be compared using most comparison operators such as =, <, <=, >, >=, <>, !=, and <=>; for information about supported operators as well as precedence and other rules that MySQL follows when comparing JSON values

Here are steps to upgrade mysql to mysql5.7 version.

1. Step1 :-

Check the myql packages previously install:-

rpm -qa | grep -i mysql

2.Step2:-

Remove the previous install packages.in our case we have MySql5.5

sudo yum remove mysql-config-5.5.58.1.19.amz1*

it will remove all the packages of mysql5.5.

Once its over we move for next step

3.Step3:-

Install EL6

sudo yum localinstall http://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm

4.Step4:-

sudo yum clean all

5. Step5:-

sudo yum update

6.Step6:-

Sudo yum install mysql-community-server

7.Step7:-

checck the myql version

mysql --version