Securing mysql

Everyone knows, first thing you have to do after installing mysql, is setting its root password. I used to do this using the mysqladmin tool like this:

/usr/bin/mysqladmin -u root password 'new-password'

For starters, you should not forget to do the same command for your other host names (-h option), but also there are still some other tasks like disabling anonymous access and removing the test databases. Today, having another mysql install, I noticed that the install script mentions this neat tool packaged with mysql to do just all that. 🙂

Just run /usr/bin/mysql_secure_installation and you’re done!