允許從任何IP地址遠(yuǎn)程訪問(wèn)MySQL數(shù)據(jù)庫(kù)我知道這一命令：GRANT ALL PRIVILEGESON database.*TO 'user'@'yourremotehost'IDENTIFIED BY 'newpassword';但是它只允許我授予一個(gè)特定的IP地址來(lái)訪問(wèn)這個(gè)遠(yuǎn)程MySQL數(shù)據(jù)庫(kù)。如果我需要它，以便任何遠(yuǎn)程主機(jī)都可以訪問(wèn)這個(gè)MySQL數(shù)據(jù)庫(kù)，該怎么辦？我該怎么做？基本上，我把這個(gè)數(shù)據(jù)庫(kù)公之于眾，這樣每個(gè)人都可以訪問(wèn)它。
3 回答
MMTTMM
TA貢獻(xiàn)1869條經(jīng)驗(yàn) 獲得超4個(gè)贊
錯(cuò)誤1130(HY000)：主機(jī)‘1.2.3.4’不允許連接到此MySQL服務(wù)器
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.
當(dāng)年話下
TA貢獻(xiàn)1890條經(jīng)驗(yàn) 獲得超9個(gè)贊
#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
添加回答
舉報(bào)
0/150
提交
取消