7.6 Ensure No 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>

'@'%'

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/benchmarks/16642

Item Details

Category: ACCESS CONTROL, MEDIA PROTECTION

References: 800-53|AC-3, 800-53|AC-5, 800-53|AC-6, 800-53|MP-2, CSCv7|14.6

Plugin: MySQLDB

Control ID: 7cb2794b099b672e5d8c6649ce4f644bcf9f7219bffb81c1834f271616a5f366