Security in MySQL/.../ Administrator Guidelines for Password Security

2.2.2管理员Guidelines for Password Security

Database administrators should use the following guidelines to keep passwords secure.

MySQL stores passwords for user accounts in themysql.usersystem table. Access to this table should never be granted to any nonadministrative accounts.

Account passwords can be expired so that users must reset them. SeeSection 4.15, “Password Management”, andSection 4.16, “Server Handling of Expired Passwords”.

Thevalidate_passwordplugin can be used to enforce a policy on acceptable password. SeeSection 6.3, “The Password Validation Component”.

A user who has access to modify the plugin directory (the value of theplugin_dirsystem variable) or themy.cnffile that specifies the plugin directory location can replace plugins and modify the capabilities provided by plugins, including authentication plugins.

Files such as log files to which passwords might be written should be protected. SeeSection 2.2.3, “Passwords and Logging”.