Information
Anonymous accounts are users with empty usernames (''). Anonymous accounts have no passwords, so anyone can use them to connect to the MySQL server.
Removing anonymous accounts will help ensure that only identified and trusted principals are capable of interacting with MySQL.
Solution
Perform the following actions to remediate this setting:
- Enumerate the anonymous users returned from executing the audit procedure.
- For each anonymous user, DROP or assign them a name.
Note: As an alternative, you may execute the mysql_secure_installation utility.
Impact:
Any applications relying on anonymous database access will be adversely affected by this change.