Wednesday, May 25, 2011

MySQL - Setting MySQL Database Server for Production Server

Run the command below:

/usr/bin/mysql_secure_installation

Action to be taken for the mysql_secure_installation

1. would request you to change your root password, 
2. remove the "test" database, and remove the anonymous account
3. remove the "root" user remote login access
4. reload privileges tables 

No comments:

Post a Comment