"MySQL ERROR 2003 (HY000): Can't connect to MySQL server on"의 두 판 사이의 차이

2014년 12월 13일 (토) 03:26 판

✔️ CentOS 6 → 우분투 12.04에서 테스트하였습니다.

ERROR 2003 (HY000): Can't connect to MySQL server on '135.79.246.80' (111)

1 문제상황

MySQL에 원격 접속 허용하였으나 접속 안됨

[root@jmnote ~]# mysql -h135.79.246.80 -uroot -pP@ssw0rd
ERROR 2003 (HY000): Can't connect to MySQL server on '135.79.246.80' (111)

[root@jmnote ~]# nmap 135.79.246.80 -p 3306 -Pn

Starting Nmap 5.51 ( http://nmap.org ) at 2014-12-13 03:24 KST
Nmap scan report for jmnote02 (135.79.246.80)
Host is up (0.00074s latency).
PORT     STATE  SERVICE
3306/tcp closed mysql

Nmap done: 1 IP address (1 host up) scanned in 0.11 seconds

[root@jmnote ~]# nc -z 175.126.100.125 3306
[root@jmnote ~]# telnet 135.79.246.80 3306
Trying 135.79.246.80...
telnet: connect to address 135.79.246.80: Connection refused

→ 방화벽에 막히지는 않았으나 서버가 거부

2 같이 보기

MySQL에 원격 접속 허용