This won’t be an exhaustive post on how to secure a MySQL server. I just want to mention a useful utility packaged with MySQL server: mysql_secure_installation. Simply run it from the command line once MySQL server is installed and running. It will prompt you with a series of questions, resulting in a more secure setup!
It only covers the very basics, but then you don’t need to remember those at least, and save yourself some typing to boot. Here’s what it does:
- Set a root password. If you already have it, you’ll need to enter it for the remaining steps.
- Remove anonymous users
- Disable non-local root access
- Remove the test database and access rules related to it
- Reload privilege tables so the above changes are in effect
A quick and easy way to follow good practices.
Possibly Related (no promises):
- Rapidly set up a MySQL database for testing
- Tune MySQL like a pro with MySQLTuner
- Troubleshooting with MySQL binary logs
- Better access to MySQL create view statements
- Advanced ordering of MySQL results
Related posts brought to you by Yet Another Related Posts Plugin.
