MySQL添加只读用户

1、查看用户 select *From user；

2、创建只读用户

CREATE USER 'readonly'@'%' IDENTIFIED WITH mysql_native_password BY 'wis123#456';

3、给用户赋予只读视图或者表权限

GRANT SELECT ON lightportal_jcxx.v_bi_a_ryjhhytj TO 'readonly'@'%';

GRANT SELECT ON lightportal_jcxx.v_bi_ryhyxx TO 'readonly'@'%';

GRANT SELECT ON lightportal_jcxx.v_bi_ryjhxx TO 'readonly'@'%';

GRANT SELECT ON lightportal_jcxx.v_bi_ryxx TO 'readonly'@'%';

4、刷新权限

FLUSH PRIVILEGES;