创建user用户,密码为123456;并赋予mysql库的查询权限
create user 'user'@'%' identified by '123456'; grant select on mysql.* to 'user'@'%';
刷新缓存
flush privileges;
移除查询权限
grant select on mysql.* to 'user'@'%';