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.user;
+-----------+------------+
| Host      | User       |
+-----------+------------+
| %         | quartz_app |
| %         | zjzc_app   |
| 127.0.0.1 | root       |
| ::1       | root       |
| localhost | root       |
+-----------+------------+
5 rows in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)




删除root 远程登录权限