Install MySQL on CentOS

How to install MySQL

Install MySQL
yum install mysql-server mysql php-mysql

How to configure MySQL

Set the MySQL service to start on boot
chkconfig –levels 235 mysqld on
Start the MySQL service
service mysqld start
Log into MySQL
mysql -u root
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’);
Drop the Any user
DROP USER ”@’localhost’;
DROP USER ”@’localhost.localdomain’;
Exit MySQL
exit