Database administrators should use the following guidelines to keep passwords secure.
MySQL stores passwords for user accounts in the
mysql.user table. Access to this table should
never be granted to any nonadministrative accounts.
Account passwords can be expired so that users must reset them. See Section 6.3.6, “Password Expiration and Sandbox Mode”.
validate_password plugin can be used to
enforce a policy on acceptable password. See
Section 18.104.22.168, “The Password Validation Plugin”.
A user who has access to modify the plugin directory (the value
variable) or the
my.cnf file that specifies
the location of the plugin directory can replace plugins and
modify the capabilities provided by plugins, including
Files such as log files to which passwords might be written should be protected. See Section 22.214.171.124, “Passwords and Logging”.