设置特定用户对数据库的操作权限
GRANT select,insert,update,delete ON *.* TO 用户@"连接的ip地址" IDENTIFIED BY "密码";
FLUSH PRIVILEGES;
指定用户 对 当前数据的操作 select,insert,update,delete
GRANT select,insert,update,delete ON *.* TO 用户@"连接的ip地址" IDENTIFIED BY "密码";
FLUSH PRIVILEGES;
指定用户 对 当前数据的操作 select,insert,update,delete
