Howtos / Articles

Remove anonymous user from MySQL

MySQL includes an anonymous user account that allows anyone to connect into the MySQL server without having a user account. This is meant only for testing, and should be removed before the database server is put into a production environment.

Run the following SQL script against the MySQL server to remove the anonymous user account:

DELETE FROM mysql.user WHERE User='';

After making changes to permissions/user accounts, make sure you flush the provilege tables using the following command:


Share this howto article!
  • Facebook
  • Twitter
  • Reddit
  • email

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>