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.