指定IP
create user 'user01'@'192.168.xx.xx' identified by 'xxxxxx';
grant select on dbname.* to 'user01'@'192.168.xx.xx';
刷新权限
flush privileges;
读权限
create user 'user02'@'%' identified by 'xxxxxxx';
grant select on wechatdb.* to 'user02'@'%';
flush privileges;
读写权限
create user 'user03'@'%' identified by 'xxxxxxx';
grant select,insert,update on wechatdb.* to 'user03'@'%';
flush privileges;
所有权限
all
测试
注意数据库服务器IP 端口访问权限
防火墙