Skip to main content

MySQL anonymous account security problem

Comments

4 comments

  • cPanelMichael
    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
  • Masimo
    Thank you very much for your reply. Its about 3861 rows! any idea?
    0
  • Masimo
    SOLVED! I found and removed all anonymous accounts by mysqltuner script. Example: mysql> DROP USER ''@'localhost';
    0
  • cPanelMichael
    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.