mysql创建用户

主数据库:
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          |
+----------------+---------------+
13 rows in set (0.00 sec)


可以看到zjzc_app 和quartz_app 本地无法登陆:




mysql> show grants for 'zjzc_app'@'10.252.148.164';
+----------------------------------------------------------------------------------------------------------------------+
| Grants for zjzc_