Install MySQL 5 on Centos 6

1) Install

// http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html

$ wget http://dev.mysql.com/get/mysql-community-release-el6-4.noarch.rpm
$ sudo yum localinstall mysql-community-release-el6-4.noarch.rpm

// Check MySQL Yum repos has been added
$ sudo yum repolist enabled | grep "mysql-community"
Failed to set locale, defaulting to C
mysql-community         MySQL Community Server          19

$ sudo yum install mysql-server

2) Set root password

// Start before changing the root password
$ sudo service mysqld start

// Set root password
$ mysql_secure_installation

3) Popular commands

$ chkconfig mysqld on
$ chkconfig --levels 235 mysqld on

// Start MySQL
$ sudo service mysqld start

// Stop MySQL
$ sudo service mysqld stop

// Check status
$ sudo service mysqld status

4) Files

// Config file
/etc/my.cnf

// Log file
/var/log/mysqld.log