MySQL Security

Sunday, 01 June 2008

Here are some steps you might consider to secure your MySQL server. 1. Run MySQL on localhost ------------------------------------ If you do not need to have access to your MySQL server from outside, you might consider to run MySQL on localhost. This can be done by editing my.cnf file (locate in /etc usualy) and adding bind-address = 127.0.0.1 to your [mysqld] section. If you cannot find my.cnf then you are running mysql with default options, you must find a my.cnf example file from your package installation files and copy it into /etc. 2. Setup a MySQL root password --------------------------------------------- This password is different from system's root password. By default after mysql installation, mysql password is not set. To set a password for mysql root: mysqladmin password mysqcurepass

Last Updated ( Tuesday, 26 April 2011 )

 

< Prev		Next >