1、改表法 mysql>use mysql; mysql>update user set host = '%' where user = 'root'; 2、授權法 例如，你想myuser使用mypassword從任何主機連接到mysql伺服器的話。 GRANT ALL PRIVILEGES ON ...
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
