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;