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


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


No comments:

Post a Comment