mysql创建只读用户

// 创建账号
create user 用户名@'网段或IP' identified by "密码";
// 授权
GRANT SElECT ON *.* TO '用户名'@'网段或IP' IDENTIFIED BY "密码";
// 刷新权限
flush privileges;
// 查询权限
show grants for 用户名@'网段或IP';