Windows连接docker mysql

谁借莪１个温暖的怀抱￠ 2023-02-14 10:21 28阅读 0赞

### 目标：在docker里安装mysql5.7并且可以通过工具访问 ###

# 安装mysql： #

查询：

docker search mysql

![format_png][]

下载（卡的直接停了再重新下，事实证明我卡了两天都没下好，Ctrl+C 停了再下30s）：

docker pull mysql

![format_png 1][]

指定版本下载命令：

docker pull mysql:5.7

查看镜像：

docker image ls

![20200602111020195.png][]

# 运行mysql #

docker run -p 3307:3306 --name mysql5.7 -e MYSQL_ROOT_PASSWORD=abc123 -d mysql:5.7

参数：

\-p 3307:3306                                                    将主机3307端口映射到容器3306端口

\-e MYSQL\_ROOT\_PASSWORD=abc123       设置远程登录的root用户密码为abc123

\--name                                                              可选，设置容器别名

mysql                                                                镜像名称

docker run -p 3307:3306 --name mysql5.7 -e MYSQL_ROOT_PASSWORD=abc123 -d mysql:5.7 --character-set-server=utf8 --collation-server=utf8_unicode_ci

指定编码集

查看运行结果：

![2020060211150625.png][]

然后就跟本地安装一样，设置远程登录：

进入容器：

docker exec -it 39dfe9a9c741 bash

39dfe9a9c741是容器的短id

全部的命令行：

root@39dfe9a9c741:/# mysql -uroot -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.30 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2020, 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> select host,user,plugin,authentication_string from mysql.user;
    +-----------+---------------+-----------------------+-------------------------------------------+
    | host      | user          | plugin                | authentication_string                     |
    +-----------+---------------+-----------------------+-------------------------------------------+
    | localhost | root          | mysql_native_password | *A4B6157319038724E3560894F7F932C8886EBFCF |
    | localhost | mysql.session | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
    | localhost | mysql.sys     | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
    | %         | root          | mysql_native_password | *A4B6157319038724E3560894F7F932C8886EBFCF |
    +-----------+---------------+-----------------------+-------------------------------------------+
    4 rows in set (0.00 sec)
    
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> flush privileges;
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> quit;
    Bye
    root@39dfe9a9c741:/# exit
    exit

提取：

1：mysql -uroot -p //登录mysql

2：select host,user,plugin,authentication\_string from mysql.user;//查询权限

3：GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' WITH GRANT OPTION;//更新登录权限

4：ALTER USER 'root'@'%' IDENTIFIED WITH mysql\_native\_password BY '123456';//设置密码

5：flush privileges;//刷新权限

6：quit;//退出mysql

7：exit//退出容器

设置密码有版本区分，具体可自行百度

都设置完毕后，重启容器。

docker restart 39dfe9a9c741

因为我是win7，用docker的话必须是虚拟机，所以查询docker的ip：

docker-machine ip default

![20200602112214160.png][]

用Navicat连接一下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIxNDU0OTcz_size_16_color_FFFFFF_t_70][]

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTAzMTU1NS8yMDE5MDMvMTAzMTU1NS0yMDE5MDMxOTIxNTg1MjgyNS0xMjQ5OTAzMDA1LnBuZw?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTAzMTU1NS8yMDE5MDMvMTAzMTU1NS0yMDE5MDMxOTIzMjgwMDYyMy05NjE5MzYzNTUucG5n?x-oss-process=image/format,png
[20200602111020195.png]: https://img-blog.csdnimg.cn/20200602111020195.png
[2020060211150625.png]: https://img-blog.csdnimg.cn/2020060211150625.png
[20200602112214160.png]: https://img-blog.csdnimg.cn/20200602112214160.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIxNDU0OTcz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200602112236720.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIxNDU0OTcz,size_16,color_FFFFFF,t_70