Windows10子系统中使用docker安装MySQL

曾经终败给现在 2022-09-10 15:24 337阅读 0赞

## **一、Windows 10 中安装子系统** ##

1.启用Windows子系统功能

![61eb55928ae65ad1f30189eaf15dab40.png][]

![83053f8ac1f144ad0cfebf27d4b0a4c1.png][]

2.安装Linux 子系统

在Microsoft Store中搜索Linux

![846c1fc97fecf0548f3a20065ee4d7e8.png][]

3.创建账号

![0075190400404ce22ac0e186e2b7f564.png][]

安装完成

![08271c61189c7634f05063b071dd907f.png][]

--------------------

**二、安装docker**

1.先卸载存在的旧版本：

sudo apt-get remove docker docker-engine docker-ce docker.io

2.更新apt包索引：

sudo apt-get update

3.安装以下包以使apt可以通过HTTPS使用存储库（repository）：

sudo apt-get install -y apt-transport-https ca-certificates curl software-properties-common

4.添加Docker官方的GPG密钥：

curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -

5.安装stable存储库：

sudo add-apt-repository \
         "deb [arch=amd64] https://download.docker.com/linux/ubuntu \
         $(lsb_release -cs) \
         stable"

6.安装docker-ce：

sudo apt-get install docker-ce

7.启动服务：

sudo service docker start

8.安装Docker for Windows

[Docker Desktop for Mac and Windows | Dockerwww.docker.com/products/docker-desktop][Docker Desktop for Mac and Windows _ Docker_www.docker.com_products_docker-desktop]

![b9dccc6ae5e8a824ffcace246ff502ff.png][]

![4071ec1a7f8e01a6a2af6eac0797cf5b.png][]

安装前确保CPU虚拟化是开着的

![c14db89057ebe0db8a38484d1ba08f57.png][]

下载后点击安装

![44e3f6f317666505ddf5362fa1c5fa33.png][]

![c9935569c154eb3390bebd0cd2acff80.png][]

安装完成后重启电脑：

![663dbf88efb3b4043c82786b1ada0738.png][]

如果重启后启动报如下错误：

![2cb4c4a9127b5ceea07239d3a0d6b6ae.png][]

下载wsl更新包：[更新包][Link 1]

9.在设置中开启2375端口

![54c20ed5bde48643d3be8c7512467263.png][]

10.修改配置

echo "export DOCKER_HOST='tcp://0.0.0.0:2375'" >> ~/.bashrc 
    source ~/.bashrc

查看docker版本 显示如下即安装成功：

![6f1a45142d8977eecc236a422275a3a9.png][]

--------------------

**三、使用docker安装MySQL**

1.拉取镜像

docker pull mysql:5.7

2.使用docker启动MySQL

docker run -itd --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7

3.进入MySQL容器

docker exec -it mysql bash 
    mysql -uroot -p123456

4.设置远程访问

grant all privileges on *.* to root@'%' identified by "password";

5.测试连接

![df3f86252290792bc75aa309fb4a66fe.png][]

[61eb55928ae65ad1f30189eaf15dab40.png]: /images/20220829/e2f11a66d3184b1694b1facbd2c49fc1.png
[83053f8ac1f144ad0cfebf27d4b0a4c1.png]: /images/20220829/c31d0c43789d4f9f87251a10f685903b.png
[846c1fc97fecf0548f3a20065ee4d7e8.png]: /images/20220829/69e2533cb026491596432fb04fe0421b.png
[0075190400404ce22ac0e186e2b7f564.png]: /images/20220829/3aed6e0b45994a8b8fba968246286512.png
[08271c61189c7634f05063b071dd907f.png]: /images/20220829/a6805c6326a044328415969a17227286.png
[Docker Desktop for Mac and Windows _ Docker_www.docker.com_products_docker-desktop]: https://link.zhihu.com/?target=https%3A//www.docker.com/products/docker-desktop
[b9dccc6ae5e8a824ffcace246ff502ff.png]: /images/20220829/23a2d6fca46e4041932a0fe3a1033b80.png
[4071ec1a7f8e01a6a2af6eac0797cf5b.png]: /images/20220829/411338058e3042ab815838d154ca5b90.png
[c14db89057ebe0db8a38484d1ba08f57.png]: /images/20220829/c739b858e4ac4e59a10aa3c972d6f647.png
[44e3f6f317666505ddf5362fa1c5fa33.png]: /images/20220829/2d608b2504064905aa0dc20fac587749.png
[c9935569c154eb3390bebd0cd2acff80.png]: /images/20220829/45df1f891069466abedc309d92df3064.png
[663dbf88efb3b4043c82786b1ada0738.png]: /images/20220829/951ade5a70c645c8afa0bfdd3fe5bab7.png
[2cb4c4a9127b5ceea07239d3a0d6b6ae.png]: /images/20220829/b0eb8af9c43d4e05abdeff7f25012d89.png
[Link 1]: https://link.zhihu.com/?target=https%3A//wslstorestorage.blob.core.windows.net/wslblob/wsl_update_x64.msi
[54c20ed5bde48643d3be8c7512467263.png]: /images/20220829/bf2d82765e7a476db0c9d18c40eec0c5.png
[6f1a45142d8977eecc236a422275a3a9.png]: /images/20220829/f1323e6c7a6b4731b04f78514c5120b4.png
[df3f86252290792bc75aa309fb4a66fe.png]: /images/20220829/835d8cd0287c479386d721636abcc76e.png