Loading...
 

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.