user:myuser  pwd:mypassword 从任何主机连接到mysql服务器

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

user:myuser  pwd:mypassword 从192.168.1.3连接到mysql服务器

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