How to install Mysql on CentOS 6.4/Redhat

1. Introduction
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is guide, howto install or upgrade MySQL Community Server latest and greatest version 5.5.33.Before installation you should read the following articles 
How to install Apache on Centos 6.4 
How to install PHP on Centos 6.4

2. Install Mysql on CentOS 6.4/Redhat

Step 1: Change Root user

#su -

or

#sudo -i

Step 2:install remi repository

#rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

#rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

 
Step 3:Check Available MySQL versions

#yum --enablerepo=remi,remi-test list mysql mysql-server 

Step 4:Update or Install MySQL 5.5.33

#yum --enablerepo=remi,remi-test install mysql mysql-server 

Step 5. Start MySQL server and autostart MySQL on boot

#/etc/init.d/mysqld start

or

#service mysqld start

#chkconfig --levels 235 mysqld on 

Step 6: MySQL Secure Installation

• Set (Change) root password
• Remove anonymous users
• Disallow root login remotely
• Remove test database and access to it
• Reload privilege tables

Start MySQL Secure Installation with following command

Note:During the installation process select Y

Step 7. Connect to MySQL database (localhost) with password

#mysql -u root -p

or

#mysql -h localhost -u root -p