Install and configure mysql server in centos / redhat linux

How to install MySQL

1. Install MySQL
   yum install mysql-server mysql php-mysql

How to configure MySQL

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