mysql 查询权限设置
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)
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
