user:myuser  pwd:mypassword 從任何主機(jī)連接到mysql服務(wù)器

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

user:myuser  pwd:mypassword 從192.168.1.3連接到mysql服務(wù)器

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