dokcer安裝mysql
docker run \
--name mysql \
-v $PWD/mysql:/var/lib/mysql \
-p 3306:3306 \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7
宿主機連接docker中的mysql
錯誤的連接方式
$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
# 可以看出這樣會報錯
正確的連接方式
$ mysql -h 127.0.0.1 -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, 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>
在docker容器中連接宿主機中的mysql
- 查看宿主機和docker之間的橋接ip
$ ifconfig
docker0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.17.0.1 netmask 255.255.0.0 broadcast 172.17.255.255
inet6 fe80::42:8aff:febc:8533 prefixlen 64 scopeid 0x20<link>
ether 02:42:8a:bc:85:33 txqueuelen 0 (以太網(wǎng))
RX packets 4779 bytes 11624681 (11.6 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 6006 bytes 441594 (441.5 KB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
# 宿主機在與容器同一局域網(wǎng)的IP地址一般是docker0對應(yīng)的IP地址段的首個地址
即（172.17.0.1 ）
- 在容器中連接宿主機的mysql
$ mysql -h 172.17.0.1 -u root -p
