mysql删除账户

 

mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *CCD57A2A8F39637CB3628862444F4D1CAD7A76FC |
| root | appsrv130 |                                           |
| root | 127.0.0.1 |                                           |
|      | localhost | *CCD57A2A8F39637CB3628862444F4D1CAD7A76FC |
|      | appsrv130 |                                           |
| root | %         | *CCD57A2A8F39637CB3628862444F4D1CAD7A76FC |
+------+-----------+-------------------------------------------+
6 rows in set (0.00 sec)

mysql> delete from user where user="";
Query OK, 2 rows affected (0.00 sec)
mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *CCD57A2A8F39637CB3628862444F4D1CAD7A76FC |
| root | appsrv130 |                                           |
| root | 127.0.0.1 |                                           |
| root | %         | *CCD57A2A8F39637CB3628862444F4D1CAD7A76FC |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)

mysql> delete from user where user="root" and host="appsrv130";
Query OK, 1 row affected (0.00 sec)

mysql> delete from user where user="root" and host="127.0.0.1";
Query OK, 1 row affected (0.00 sec)

mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *CCD57A2A8F39637CB3628862444F4D1CAD7A76FC |
| root | %         | *CCD57A2A8F39637CB3628862444F4D1CAD7A76FC |
+------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)