mysql> select user,host from mysql.user;
±-----±--------------+
| user | host |
±-----±--------------+
| root | 127.0.0.1 |
| root | ::1 |
| | localhost |
| root | localhost |
| | web01.gao.com |
| root | web01.gao.com |
±-----±--------------+
drop user ‘’@‘localhost’;
drop user ‘’@‘web01.gao.com’;
drop user ‘root’@‘web01.gao.com’;
drop user ‘root’@’::1’;
mysql> select user,host from mysql.user;
±-----±----------+
| user | host |
±-----±----------+
| root | 127.0.0.1 |
| root | localhost |
±-----±----------+
如果遇到drop删不掉的时候
delete from mysql.user where host=”要删除的host”