1、
mysql -u root -p
登录到本机的MySQL
2、use mysql;选择进入mysql库下
3、create user 'read_only_user'@'%' identified by 'Admin123!';
创建只读用户
flush privileges;
刷新权限
4、GRANT SELECT ON *.* TO 'read_only_user'@'%' WITH GRANT OPTION;
赋予该用户只读权限select权限;
5、select * from user where User='read_only_user' \G;
查询该用户的权限