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)

mysql 查询权限设置