7.5 Ensure Passwords are Set for All MySQL Accounts

Information

Blank passwords allow a user to login without using a password.

Rationale:

Without a password only knowing the username and the list of allowed hosts will allow someone to connect to the server and assume the identity of the user. This, in effect, bypasses authentication mechanisms.

Solution

For each row returned from the audit procedure, set a password for the given user using the following statement (as an example):

SET PASSWORD FOR <user>@'<host>' = PASSWORD('<clear password>')

Note: Replace <user>, <host>, and <clear password> with appropriate values.

See Also

https://workbench.cisecurity.org/files/3848

Item Details

Category: IDENTIFICATION AND AUTHENTICATION

References: 800-53|IA-5(1), CSCv7|4.4

Plugin: MySQLDB

Control ID: 0ab088434a19fe5984deab2aec4ca4566572702db785b84cb5fa2feaf032bf56