我刚刚拉出并运行了官方 Docker MySQL映像,并将其本地运行在我的本地计算机上机器:
docker run --name mydb -e MYSQL_ROOT_PASSWORD=12345 -d mysql:5.7.11该屏幕上的说明告诉您如何从另一个容器(配置为命令行客户端)内部连接到MySQL服务器(容器).但是我有一个通用的JDBC胖客户端( SQuirreL ),并且想知道如何连接到我的docker容器. /p>
对于JDBC连接字符串,我需要同时提供主机名和 dbname ,该怎么用?我以为Docker容器可以通过我的主机OS寻址,但是我实际上还没有创建任何数据库,所以我不确定我可以提供什么dbname值:
jdbc:mysql://<hostname>:3306/<dbname>解决方案
您可以通过转发3306运行实例:
$ docker run --expose=3306 -p 3306 mysql请参见传入端口.
您指定:
jdbc:mysql://127.0.0.1:3306/<dbname>您的命令将变为:
$ docker run --name mydb -e MYSQL_ROOT_PASSWORD=12345 -d --expose=3306 -p 3306 mysql:5.7.11您可能需要更改MySQL配置.
可以通过以下方式进入容器内部:
$ docker exec -it mydb bash然后您可以:
$ echo "bind-address = 0.0.0.0" >> /etc/mysql/myf别忘了重新加载mysql.
然后,您必须创建数据库并导入架构(如果需要).
$ mysql -uroot -p12345 -e"CREATE DATABASE mydb" $ mysql -uroot -p12345 mydb < mydb-schema.sqlI just pulled and run the official Docker MySQL image and have it running locally on my machine:
docker run --name mydb -e MYSQL_ROOT_PASSWORD=12345 -d mysql:5.7.11The instructions on that screen tell you how to connect to the MySQL server (container) from inside yet another container (which is configured as a command-line client). But I have a generic JDBC fat client (SQuirreL) and am wondering how to connect to my docker container.
For the JDBC connection string, I need to provide both a hostname and a dbname, what can I use? I would imagine the Docker container is somehow addressable from my host OS, but I haven't actually created any databases yet, so I'm not sure what dbname value I can supply:
jdbc:mysql://<hostname>:3306/<dbname>解决方案
You could run your instance with forwarding 3306:
$ docker run --expose=3306 -p 3306 mysqlSee incoming ports.
The you specify:
jdbc:mysql://127.0.0.1:3306/<dbname>You command become:
$ docker run --name mydb -e MYSQL_ROOT_PASSWORD=12345 -d --expose=3306 -p 3306 mysql:5.7.11You might need to change the MySQL configuration.
Can go inside the container with:
$ docker exec -it mydb bashAnd then you could:
$ echo "bind-address = 0.0.0.0" >> /etc/mysql/myfDon't forget to reload mysql.
Then you have to create the database and import your schema (if needed).
$ mysql -uroot -p12345 -e"CREATE DATABASE mydb" $ mysql -uroot -p12345 mydb < mydb-schema.sql
更多推荐
从主机连接到Docker容器
发布评论