mysql遠程訪問的權限，mysql遠程訪問權限

mysql遠程訪問的權限，mysql遠程訪問權限

1、改表法 

mysql>use mysql; 

mysql>update user set host = '%' where user = 'root'; 

2、授權法 

例如，你想myuser使用mypassword從任何主機連接到mysql服務器的話。 

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

如果你想允許用戶myuser從ip為192.168.1.6的主機連接到mysql服務器，並使用mypassword作為密碼 

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

刷新

FLUSH PRIVILEGES