设置MySQL表的只读授权和取消授权

设置MySQL表的只读授权和取消授权

MySQL8的操作

MySQL 8需要将创建用户和授权分开执行。

创建用户：

CREATE USER readonly@'%' IDENTIFIED BY '密码xxxxxx';
FLUSH PRIVILEGES;

授权：

GRANT SELECT ON dbname.* to readonly@'%';
FLUSH PRIVILEGES;

授权所有表的只读权限

GRANT SELECT ON spug.* to grafana@'%' IDENTIFIED BY '******';
FLUSH PRIVILEGES;

授权制定表的只读权限

GRANT SELECT ON spug.blocks to grafana@'%' IDENTIFIED BY '******';
GRANT SELECT ON spug.miner_lucky_val to grafana@'%';
FLUSH PRIVILEGES;

撤销对表的授权

revoke select on spug.* from grafana@'%';
FLUSH PRIVILEGES;