sql grant 授权

grant select on tb_base_user to erpopr;

grant select,update,insert,delete on tb_main_product to erpdata;

模板

GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password';

如果没有密码：

GRANT ALL ON *.* to root@'192.168.1.4' ;