mysql 授权指定库 mysql创建新用户并给授权指定的数据库权限

指定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 端口访问权限

防火墙