允許從任何IP地址遠程訪問MySQL數據庫我知道這一命令：GRANT ALL PRIVILEGESON database.*TO 'user'@'yourremotehost'IDENTIFIED BY 'newpassword';但是它只允許我授予一個特定的IP地址來訪問這個遠程MySQL數據庫。如果我需要它，以便任何遠程主機都可以訪問這個MySQL數據庫，該怎么辦？我該怎么做？基本上，我把這個數據庫公之于眾，這樣每個人都可以訪問它。
3 回答
MMTTMM
TA貢獻1869條經驗 獲得超4個贊
錯誤1130(HY000)：主機‘1.2.3.4’不允許連接到此MySQL服務器
vim /etc/mysql/my.cnf
#bind-address = 127.0.0.1#skip-networking
~ /etc/init.d/mysql restart
USERNAMEPASSWORD
mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
USERNAMEPASSWORD
mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
USERNAME & PASSWORD
SELECT * from information_schema.user_privileges where grantee like "'USERNAME'%";
mysql> FLUSH PRIVILEGES;
mysql -h HOST -u USERNAME -pPASSWORD
mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'USERNAME'@'%';Following will revoke all options for USERNAME from particular IP:mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'USERNAME'@'1.2.3.4'; Its better to check information_schema.user_privileges table after running REVOKE command.
當年話下
TA貢獻1890條經驗 獲得超9個贊
#nano /etc/mysql/my.cnf
...... ..... # Instead of skip-networking the default is now to listen only on# localhost which is more compatible and is not less secure.bind-address = 127.0.0.1 bind-address = 192.168.0.116..... ......
stop mysqlstart mysql
#/etc/init.d/mysql restart
mysql -u username -h 192.168.0.116 -p
添加回答
舉報
0/150
提交
取消