NOTE : Nessus has not performed this query, and this check is only provided for informational purposes.
Solution
Use -p without password and then enter the password when prompted, use a properly secured .my.cnf file, or store authentication information in encrypted format in .mylogin.cnf.