创建一个只能读取,不能修改的账号
CREATE USER '账号'@'%' IDENTIFIED BY '密码';
GRANT SELECT ON 数据库名.* TO '账号'@'密码';
FLUSH PRIVILEGES;
查看数据库账号
select user,host from user;
修改某个账号的密码
update mysql.user set password = password('新密码')
where user = '账号' and host = '账号host';
修改完记得刷新
FLUSH PRIVILEGES;