CentOS 6.4 - Install and Set up MySQL for PHP

Here is a quick guide for setting up your mysql server on CentOS and performing some basic/essential security

yum install mysql-server mysql php-mysql php-mysqli
Set mysql to start on boot
chkconfig --levels 235 mysqld on
Set the root users password (or any other user you want)
mysqladmin -u root password $YOUR_PASSWORD_HERE
Prevent someone accessing mysql without a password with the 'any' user like so:

mysql -u any

Solution:

mysql -u root -p$PASSWORD_HERE
DROP USER ''
DROP USER ''@localhost

References

• Antoine Solutions Development - Mysql