创建read只读账号
CREATE USER 'read'@'172.24.80.120' IDENTIFIED BY 'read123';
指定只读数据库
GRANT SELECT ON dingdan.* TO 'read'@'172.24.80.120';
撤销对特定表的访问权限
REVOKE SELECT ON dingdan.user FROM 'read'@'172.24.80.120';
刷新权限
FLUSH PRIVILEGES;
12-09
1910
08-31
1370
09-09
594
05-25