Skip navigation links
MySQL 5.1 with Maria Reference Manual :: 4 MySQL Programs :: 4.4 MySQL Installation-Related Programs :: 4.4.6 mysql_secure_installation — Improve MySQL Installation Security
4.4.7 mysql_tzinfo_to_sql — Load the Time Zone Tables »
Section Navigation      [Toggle]

4.4.6. mysql_secure_installation — Improve MySQL Installation Security

This program enables you to improve the security of your MySQL installation in the following ways:

  • You can set a password for root accounts.

  • You can remove root accounts that are accessible from outside the local host.

  • You can remove anonymous-user accounts.

  • You can remove the test database, which by default can be accessed by anonymous users.

Invoke mysql_secure_installation without arguments: 

shell> mysql_secure_installation

The script will prompt you to determine which actions to perform.