创建user用户，密码为123456；并赋予mysql库的查询权限

create user 'user'@'%' identified by '123456';
grant select on mysql.* to 'user'@'%';

刷新缓存

flush privileges;

移除查询权限

grant select on mysql.* to 'user'@'%';