Docker:無法連接容器中的mysql

Question

• 環境

  • Macbook pro 10.10

  • DockerToolbox 1.8 & Docker 1.8.2

• 先看一下錯誤輸出吧

$ mysql -uroot -p -h192.168.99.100 -P3306        
Enter password: 
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.99.100' (61)

$ mysqladmin -h192.168.99.100 --port=3306 version                                                                                                                                                      127 ↵
mysqladmin: connect to server at '192.168.99.100' failed
error: 'Can't connect to MySQL server on '192.168.99.100' (61)'
Check that mysqld is running on 192.168.99.100 and that the port is 3306.
You can check this by doing 'telnet 192.168.99.100 3306'

DEBUG的過程

• 容器狀態&端口映射

$ docker ps -l 
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                    NAMES
b20584bc086e        sunzy/mysql         "/usr/bin/mysqld_safe"   21 minutes ago      Up 21 minutes       0.0.0.0:3306->3306/tcp   mysql

• 宿主機的IP

$ docker-machine ls
NAME      ACTIVE   DRIVER       STATE     URL                         SWARM
default   *        virtualbox   Running   tcp://192.168.99.100:2376   
$ docker-machine ls
NAME      ACTIVE   DRIVER       STATE     URL                         SWARM
default   *        virtualbox   Running   tcp://192.168.99.100:2376   

• PING

$ ping 192.168.99.100                                                                                                                                                                                    1 ↵
PING 192.168.99.100 (192.168.99.100): 56 data bytes
64 bytes from 192.168.99.100: icmp_seq=0 ttl=64 time=0.347 ms
64 bytes from 192.168.99.100: icmp_seq=1 ttl=64 time=0.388 ms
64 bytes from 192.168.99.100: icmp_seq=2 ttl=64 time=0.272 ms

• Telnet

$ telnet 192.168.99.100 3306                                                                                                                                                                             1 ↵
Trying 192.168.99.100...
telnet: connect to address 192.168.99.100: Connection refused
telnet: Unable to connect to remote host

• 在容器內連接

# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.5.44-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
mysql> 

• mysql允許任意IP連接

mysql> select user,host,password from mysql.user;
+------------------+--------------+-------------------------------------------+
| user             | host         | password                                  |
+------------------+--------------+-------------------------------------------+
| root             | localhost    | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root             | e611e15f9c9d | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root             | 127.0.0.1    | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root             | ::1          |                                           |
| debian-sys-maint | localhost    | *1BD91232C0D2D2B5500129217CEF09B7EE71ABEC |
| root             | %            | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+------------------+--------------+-------------------------------------------+

Answer 1

突然想起來以前用vagrant也遇到這種情況，不過那個報的是2013-Lost connection to MySQL server at ‘reading initial communication packet錯誤=>圍觀

1. 開啟mysql設定檔 sudo vim /etc/mysql/my.cnf

2. 找到bind-address,把127.0.0.1改成0.0.0.0或註解掉該行

3. 重啟mysql

試了一下，正常了

Answer 2

宿主機的防火牆 開著麼？ sudo service iptables status 看看。

在宿主機上 執行 sudo netstat -lnp | grep 3306 看看連接埠3306 被哪個程序使用中。

Answer 3

docker run --name djistore_mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root -d mysql:5.6.27 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

連接到該 MySQL 服務

mysql -h 192.168.99.100 -u root -p

相關的日誌

➜  ~ mysql -h 192.168.99.100 -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.01 sec)