加载中…mysql的show grants命令真的挺好用的
(2017-05-17 08:10:51)
标签：
it |
对比一下，如果用oracle的使用习惯，是这样查询的：
mysql> select * from user where user='dba'\G
*************************** 1. row
***************************
Create_tablespace_priv: N
1 row in set (0.00 sec)
除此之外在mysql还可能要查表级和host级别的权限，不直观，不方便，查出来也不知道怎么复制这样的用户权限。实际上mysql是这么玩的：
mysql> show grants for 'dba'@'localhost';
+---------------------------------------------------------------------------------------------+
| Grants for dba@localhost
|
+---------------------------------------------------------------------------------------------+
| GRANT RELOAD, SUPER, REPLICATION CLIENT ON *.* TO
'dba'@'localhost'
|
| GRANT CREATE TEMPORARY TABLES ON `mysql`.* TO
'dba'@'localhost'
|
| GRANT SELECT, INSERT, UPDATE, CREATE, DROP ON
`mysql`.`backup_history` TO 'dba'@'localhost' |
| GRANT INSERT, UPDATE, CREATE, DROP ON
`mysql`.`ibbackup_binlog_maker` TO 'dba'@'localhost'
|
| GRANT INSERT, UPDATE, CREATE, DROP ON
`mysql`.`backup_progress` TO 'dba'@'localhost'
|
+---------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)
是不是舒服多了，直接复制语句就可以
喜欢
0
赠金笔