Install MySQL Server 5.6 in CentOS 6.x and Red Hat 6.x Linux

In this tutorial we will learn how to install MySQL Server 5.6 in CentOS 6.x and RHEL 6.x by using yum command.The package is “Architecture Independent” hence applicable to 32 bit(i386) and 64 bit(x86_64) operating system.

Details of system where practical has been applied

Operating System: CentOS 6.5
Arch: x86_64 and i386 (Both)

To install the MySQL server 5.6,follow the given below steps.

Step 1: Login into the Server and download the yum repo rpm package.
(URL: http://dev.mysql.com/downloads/repo/)

yum install wget
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

Step 2: Now install the downloaded rpm package.

rpm -ivh mysql-community-release-el6-5.noarch.rpm

Step 3: Now install the mysql server by using yum command.
Note: The yum command by-default also install the dependencies

yum install mysql-server

Step 4: After installation start the mysql server

/etc/init.d/mysqld start

Other options:

Usage: /etc/init.d/mysqld {start|stop|status|restart|condrestart|try-restart|reload|force-reload}

Step 5: Because the MySQL server is just installed it has blank mysql root password. To reset the mysql root password.

You can use the given below command, and follow the instruction

mysql_secure_installation

You can also use the given below alternate method

Login into mysql server. Because it is freshly installed hence root password is blank

mysql -u root

After login you will get mysql propmt. Run the given commands (remove mysql> if you are doing copy paste these commands)

mysql> use mysql;
mysql> update user set password=PASSWORD("GIVE-NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit