一、创建Mysql只读用户
– 创建用户 用户名:readonly 密码:123456 可自行更改
CREATE USER 'readonly'@'%' IDENTIFIED BY '123456';
– 赋予用户对应数据库只读权限 库名:mydb 用户:readonly
GRANT SELECT ON mydb.* TO 'readonly'@'%';
– 赋予用户所有数据库只读权限 用户:readonly
GRANT SELECT ON *.* TO 'readonly'@'%';
– 刷新权限
FLUSH PRIVILEGES;
– 查询用户
SELECT User, Host FROM mysql.user;