MySQL anonymous account security problem
How to fix this MySQL security problem?
[!!] User '@localhost' is an anonymous account.
-
Hello :) Could you provide more information about where you noticed that warning? These commands will tell you if a user is configured without a password: mysql SELECT User, Host, Password FROM mysql.user;
Note: Please don't post the output from that command as it includes password hashes. Documentation on this is available at: MySQL :: MySQL 5.6 Reference Manual :: 2.10.4 Securing the Initial MySQL Accounts Thank you.0 -
Thank you very much for your reply. Its about 3861 rows! any idea? 0 -
SOLVED! I found and removed all anonymous accounts by mysqltuner script. Example: mysql> DROP USER ''@'localhost'; 0 -
I am happy to see you were able to address the issue. Thank you for updating us with the outcome. 0
Please sign in to leave a comment.
Comments
4 comments