MySQL 授權，回收許可權，查看許可權

標籤：local   connect   層級   slist   time   obj   upd   ESS   TE   

show GRANTS for [email protected];
flush privileges;
SHOW PROCESSLIST;

#全域授權，回收許可權
GRANT ALL ON *.* TO ‘testzzq‘@‘localhost‘;
REVOKE ALL ON *.* FROM ‘testzzq‘@‘localhost‘;
flush privileges;

#資料庫層級,授權，回收許可權
GRANT ALL PRIVILEGES ON cs TO ‘testzzq‘@‘localhost‘;
REVOKE ALL PRIVILEGES ON cs FROM ‘testzzq‘@‘localhost‘;
flush privileges;

#資料庫表層級,授權，回收許可權
GRANT ALL PRIVILEGES ON cs.apply_reduction TO ‘testzzq‘@‘localhost‘ WITH MAX_QUERIES_PER_HOUR 2;
REVOKE ALL PRIVILEGES ON cs.apply_reduction FROM ‘testzzq‘@‘localhost‘;
flush privileges;

授權公式：
GRANT
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
ON [object_type] priv_level
TO user [auth_option] [, user [auth_option]] ...
[REQUIRE {NONE | tls_option [[AND] tls_option] ...}]
[WITH {GRANT OPTION | resource_option} ...]

resource_option: {
| MAX_QUERIES_PER_HOUR count
| MAX_UPDATES_PER_HOUR count
| MAX_CONNECTIONS_PER_HOUR count
| MAX_USER_CONNECTIONS count
}

The number of queries an account can issue per hour
一個帳號每小時可以發起查詢操作的個數
The number of updates an account can issue per hour
一個帳號每小時可以發起更新操作的個數
The number of times an account can connect to the server per hour
一個帳號每小時可以串連伺服器的次數
The number of simultaneous connections to the server by an account
一個帳號同時可以串連伺服器的個數,

#查看許可權

show GRANTS for ‘testzzq‘@‘localhost‘

 

MySQL 授權，回收許可權，查看許可權