MySQL : MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a number of databases.

How to install MySQL

1. Installing MySQL

yum install mysql-server mysql php-mysql

2.How to configure MySQL :

a. Set the MySQL service to start on boot

b. chkconfig --levels 235 mysqld on

3. Start the MySQL service

service mysqld start

4. Log into MySQL

mysql -u root

5.Set the root user password for all local domains

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password');

SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('new-password');

SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new-password');

6. Drop the Any user

DROP USER ''@'localhost';

DROP USER ''@'localhost.localdomain';

7. Exit MySQL

exit