Networking HowTos
Networking HowTos

Remove anonymous user from MySQL

April 15, 2012 Database, 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:

FLUSH PRIVILEGES;

You Might Also Like