删除root 任何远程机器登录权限

mysql> select Host,User from mysql.user;
+----------------+---------------+
| Host           | User          |
+----------------+---------------+
| %              | query_all     |
| %              | query_dev     |
| %              | root          |
| %              | zjzc_dba      |
| %              | zjzc_limit_cn |


| 10.171.243.55  | quartz_app    |
| 10.171.243.55  | zjzc_app      |
| 10.252.148.164 | quartz_app    |
| 10.252.148.164 | zjzc_app      |



| 127.0.0.1      | root          |
| ::1            | root          |
| jrhdpt01       | root          |
| localhost      | root          |
+----------------+---------------+


mysql> delete from mysql.user where User='root' and Host='%';
Query OK, 1 row affected (0.00 sec)

mysql> select Host,User from mysql.user where User='root' and Host='%';
Empty set (0.00 sec)

mysql> select Host,User from mysql.u