授權任意主機連接：

賬號myuser密碼password任何主機連接到mysql服務器
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

指定IP連接

允許用戶myuser從IP為192.168.1.3的主機連接到mysql服務器，并使用password作為密碼
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY 'password' WITH GRANT OPTION;

轉載請注明出處 AE博客|墨淵 ? mysql修改用戶連接權限