I have a docking machine and the mysql container is running.
~ ▶ 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
logs from 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)
How to connect to mysql instance in this container from my localhost OSX laptop using Sequel Pro.
I use the following settings, but I cannot connect:
Unable to connect to host 192.168.99.100 or request timeout.
Make sure the address is correct and you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).
MySQL said: "Cannot connect to MySQL server on" 192.168.99.100 "(61)
source share