您的位置:首页 > 博客中心 > 数据库 >

mysql 查询权限设置

时间:2022-03-14 03:52


mysql> grant select on aaa.* to query identified by ‘query‘;

Query OK, 0 rows affected (0.00 sec)


mysql> show grants for query

    -> ;

+------------------------------------------------------------------------------------------------------+

| Grants for query@%                                                                                   |

+------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO ‘query‘@‘%‘ IDENTIFIED BY PASSWORD ‘*9C1A98FDC07907D9E7956EBBC4741B1E9C2B5DBB‘ |

| GRANT SELECT ON `aaa`.* TO ‘query‘@‘%‘                                                               |

+------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)


热门排行

今日推荐

热门手游