How to secure MySQL?
Here are some tips for securing your MySQL server.
Do
- Set the Root password and delete the test database: in CentOS/RedHat run the command
mysql_secure_installation
. - Review your current MySQL users and remove unused credentials.
Avoid
- Using Passwords directly in the CLI, this shows on the process list and in shell history.
- When adding MySQL users try not to use wildcards for hostname values.
For more information, please refer to MySQL's official documentation.