今天安装mysql-5.1.62后，登陆进去查看用户，发现有四个 mysqlgt; select user,host from user;+------+--------------+| user
今天安装mysql-5.1.62后，登陆进去查看用户，，发现有四个
mysql> select user,host from user;
+------+--------------+
| user | host        |
+------+--------------+
|      | mysql-server |
| root | mysql-server |
|      | localhost    |
| root | localhost    |
+------+--------------+
4 rows in set (0.00 sec)
其中两个看不到用户名，通过正常的drop user无法删除
drop user @localhost
drop user @mysql-server
结果还是可以看得到，并没有被删除。
后来想到个方法，就是直接删除这个表的内容
mysql> delete from user where user='';
query ok, 2 rows affected (0.01 sec)
mysql> select user,host from user;
+------+--------------+
| user | host        |
+------+--------------+
| root | mysql-server |
| root | localhost    |
+------+--------------+
2 rows in set (0.00 sec)
mysql> delete from user where host=mysql-server;
query ok, 1 row affected (0.00 sec)
mysql> select user,host from user;               
+------+-----------+
| user | host      |
+------+-----------+
| root | localhost |
+------+-----------+
1 row in set (0.00 sec)
最后再刷新下就好了。
mysql> flush privileges;
query ok, 0 rows affected (0.00 sec)
相关阅读：
增加mysql用户
mysql用户管理
linux下 mysql 用户的管理