Wednesday, January 9, 2013

MySQL Basic Hardening

Below are the basic hardening steps

1.Get rid of the test database, which is accessible to everyone.

mysql> drop database test;

2. Remove anonymous users

mysql> use mysql;

mysql> delete from db;

mysql> delete from user where not (host="localhost" and user="root");

mysql> flush privileges;

image

3. Change root Password

By default root password in empty

mysql> SET PASSWORD FOR root@localhost=PASSWORD(' New_Password');

image

4. Stop and Stat MySQL

image

No comments:

Post a Comment