主数据库:
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_
mysql创建用户
最新推荐文章于 2023-09-05 11:16:42 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)