MySQL 创建只读用户
MySQL 5.7
- 创建用户 设置只读权限
GRANT SElECT ON *.* TO 'username'@'%' IDENTIFIED BY "password";
select 可以更改成所有 all username对应账号 password对应密码 %是所有ip地址 可以更改
- 刷新
flush privileges;
MySQL 8.0
- 创建用户设置只读权限
CREATE USER `username`@`%` IDENTIFIED BY 'passowrd';
- 授予权限
GRANT SELECT ON *.* TO `username`@`%` WITH GRANT OPTION;
- 删除权限
REVOKE all privileges ON *.* FROM 'username'@'%';
- 刷新
flush privileges;