Before we had Securing PHP and prior to that we had Securing Apache so I think it is only obvious that we move onto MySQL as the total fortification of any LAMP solution would not be complete without it.

This article does a great job of running you through step-by-step the security measures necessary to secure a MySQL install along with the justifications for why certain things are being done.

Sections covered:

  • Installation
  • Chrooting MySQL
  • The MySQL root user and default accounts
  • MySQL privilege system and MySQL users
  • Local Security
  • Securing remote access
  • Backup
  • Server startup