vs如何连接docker上的mysql_如何使用Sequel Pro连接到在docker上运行的mysql

本文档介绍了如何从运行OSX的本地主机使用Sequel Pro连接到在Docker容器中运行的MySQL实例。通过查看docker-machine IP地址、容器端口映射以及配置连接参数,尝试连接但遇到连接超时的问题。
摘要由CSDN通过智能技术生成

我有一个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的日志记录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的localhost笔记本电脑连接到此容器中的mysql实例.

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

a0wev.png

Unable to connect to host 192.168.99.100,or the request timed out.

Be sure that the address is correct and that you have the necessary

privileges,or try increasing the connection timeout (currently 10

seconds).

MySQL said: Can’t connect to MySQL server on ‘192.168.99.100’ (61)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值