如何使用Sequel Pro连接运行在Docker上的MySQL

10
我有一个docker-machine,其中运行着一个mysql容器。
~
▶ boot2docker ip
192.168.59.103
~                                                                                                                                                                       
▶ docker-machine ip default
192.168.99.100

~
▶ docker-machine ls
NAME      ACTIVE   DRIVER       STATE     URL                         SWARM   DOCKER   ERRORS
default   *        virtualbox   Running   tcp://192.168.99.100:2376           v1.9.1

~
▶ docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                              NAMES
b14062dd1e25        mysql:5.6           "/entrypoint.sh mysql"   6 hours ago         Up 6 hours          3306/tcp, 0.0.0.0:3306->9090/tcp   i-mysql

来自docker logs i-mysql的日志

2016-01-20 04:14:41 1 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-20 04:14:41 1 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-20 04:14:41 1 [Note] InnoDB: Waiting for purge to start
2016-01-20 04:14:41 1 [Note] InnoDB: 5.6.28 started; log sequence number 1625997
2016-01-20 04:14:41 1 [Note] Server hostname (bind-address): '*'; port: 3306
2016-01-20 04:14:41 1 [Note] IPv6 is available.
2016-01-20 04:14:41 1 [Note]   - '::' resolves to '::';
2016-01-20 04:14:41 1 [Note] Server socket created on IP: '::'.
2016-01-20 04:14:41 1 [Warning] 'proxies_priv' entry '@ root@b14062dd1e25' ignored in --skip-name-resolve mode.
2016-01-20 04:14:41 1 [Note] Event Scheduler: Loaded 0 events
2016-01-20 04:14:41 1 [Note] mysqld: ready for connections.
Version: '5.6.28'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)

如何使用Sequel Pro在我本机的OSX上连接到这个容器中的mysql实例。

我使用以下设置,但是似乎无法连接:

enter image description here

无法连接到主机192.168.99.100,或请求超时。请确保地址正确且您具有必要的权限,或尝试增加连接超时时间(当前为10秒)。MySQL报错:无法连接到位于'192.168.99.100'的MySQL服务器(61)。
2个回答

1
你正在将容器端口9090暴露给主机端口3306。也许你想要反过来。当你启动容器时,请将-p标志参数从9090:3306更改为3306:9090。

0

您是否已经为来自主机IP的请求添加了根用户的权限?


网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接