無(wú)法連接到MySQL服務(wù)器錯(cuò)誤111我在Linux Box IP=192.168.1.100上安裝了MySQL服務(wù)器，但是當(dāng)我試圖連接到這個(gè)IP時(shí)，總是出錯(cuò)(111)。但是使用localhost和127.0.0.1是可以的。beer@beer-laptop# ifconfig | grep "inet addr"
inet addr:127.0.0.1 Mask:255.0.0.0
inet addr:192.168.1.100 Bcast:192.168.1.255 Mask:255.255.255.0
beer@beer-laptop# mysql -ubeer -pbeer -h192.168.1.100
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111)
beer@beer-laptop# mysql -ubeer -pbeer -hlocalhost
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 160
Server version: 5.1.31-1ubuntu2 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
beer@beer-laptop# mysql -ubeer -pbeer -h127.0.0.1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 161
Server version: 5.1.31-1ubuntu2 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>從另一臺(tái)機(jī)器連接，也會(huì)出錯(cuò)111。another@another-laptop# mysql -ubeer -pbeer -h192.168.1.100
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111)在這種情況下，使用localhost/127.0.0.1和192.168.1.100有多大的區(qū)別。我不知道如何從另一臺(tái)機(jī)器連接這個(gè)數(shù)據(jù)庫(kù)。請(qǐng)幫幫忙。謝謝。
3 回答
慕俠2389804
TA貢獻(xiàn)1719條經(jīng)驗(yàn) 獲得超6個(gè)贊
bind-address = 127.0.0.1
my.cnf
sudo service mysql restart
達(dá)令說(shuō)
TA貢獻(xiàn)1821條經(jīng)驗(yàn) 獲得超6個(gè)贊
localhost
bind-addressmysqldmy.cnf
湖上湖
TA貢獻(xiàn)2003條經(jīng)驗(yàn) 獲得超2個(gè)贊
root
CREATE USER 'root'@'192.168.1.100' IDENTIFIED BY '***';GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.1.100' IDENTIFIED BY '***' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
mysql -ubeer -pbeer -h192.168.1.100
添加回答
舉報(bào)
0/150
提交
取消