创建MySQL只读权限用户
-- 首先查看mysql中所有的用户
SELECT user,host FROM mysql.user;
-- 查看指定用户的权限情况
SELECT * FROM mysql.user WHERE user='root'
-- 1.创建一个用户
CREATE USER 'aqrcode'@'%' IDENTIFIED BY 'aqrcode123';
-- 2.给用户赋予只读权限
GRANT SELECT ON AQRCODE_APP_ADMIN.g_score_result TO 'aqrcode'@'%';
GRANT [权限]
ON [库.表]
TO [用户名]@[IP]
IDENTIFIED BY [密码]
-- 3.刷新权限
FLUSH PRIVILEGES;