Remove empty users with more MySQL accounts

By default, after MySQL is installed, there will be anonymous users, or you can call an empty user, enter MySQL and then go directly to MySQL.

The anonymous user has certain permissions through show DATABASES; you can view the INFORMATION_SCHEMA database.

Deleting a statement is simple, log in with a user with corresponding user rights, such as root.

You can query the empty user first:

1, SELECT user,host,password from mysql.user;

2. Recommended deletion

Remote connection

Delete from Mysql.user where host= '% ';

Empty user

DELETE from Mysql.user WHERE user= ';

FLUSH privileges;

This can be done in a moment

Of course, you can also set an arbitrary password for anonymous users.

SET PASSWORD for ' @localhost = PASSWORD (' fs_^s%d1l3 ');

FLUSH privileges;

Remove empty users with more MySQL accounts