Mysql远程连接赋予权限

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 

flush privileges; 
只赋予增删该查的话

GRANT update,select,insert,delete on databasename.tablename to 'myuser'@'ip_address' identified by 'password' with grant option;
flush privileges;