9.5 Ensure No Replication Users Have Wildcard Hostnames

Information

MySQL can make use of host wildcards when granting permissions to users on specific databases. For example, you may grant a given privilege to '<user>'@'%'.

Rationale:

Avoiding the use of wildcards within hostnames helps control the specific locations from which a given user may connect to and interact with the database.

Solution

Perform the following actions to remediate this setting:

Enumerate all users returned after running the audit procedure

Either ALTER the user's host to be specific or DROP the user

See Also

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

Item Details

Category: ACCESS CONTROL

References: 800-53|AC-2, CSCv7|14.6

Plugin: MySQLDB

Control ID: 10a170d283b60acf597bacf2cf2afc8d71b749d0d5fd6b43b8a026f1e129e6dc