Install MySQL Server 5.6 in CentOS6.*/Red Hat6.* from YUM Repo

Hi friends to install mysql-server 5.6 on Centos6.* /Rhel6.* follow below step .

Step 1 => Login into your Server and run below command to install you repo.

#rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Retrieving http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Preparing... ###############################[100%]
1:mysql-communityrelease######################[100%]

Step 2 => Update your yum repository by running below command .

#yum update

Step 3 => Now install the mysql-server by using below yum command.

#yum install mysql-server  -y

Step 4: After installation start the mysql server services

#service mysqld restart
#chkconfig mysqld on


#mysql -V   (To check mysql installed version )
mysql  Ver 14.14 Distrib 5.6.22, for Linux (x86_64)


Step 5: Set mysql root password  by using below command

 A : Use can set mysql root password by below command

  #/usr/bin/mysqladmin -u root password 'new-password'
  #/usr/bin/mysqladmin -u root -h hostname password 'new-password'

OR

  #/usr/bin/mysql_secure_installation

 OR

/usr/bin/mysql -uroot
mysql> use mysql;
mysql> update user set password=PASSWORD("root123") where user='root';
mysql> flush privileges;
mysql> quit


#######   Mysql server 5.6 setup successfully enjoy it ###########