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