1. 首先我们需要拉取镜像到本地来，这里我们拉取最新的下来
    1. docker pull mysql:latest
    2. latest: Pulling from library/mysql
    3. 80369df48736: Pull complete 
    4. e8f52315cb10: Pull complete 
    5. cf2189b391fc: Pull complete 
    6. cc98f645c682: Pull complete 
    7. 27a27ac83f74: Pull complete 
    8. fa1f04453414: Pull complete 
    9. d45bf7d22d33: Pull complete 
    10. 3dbac26e409c: Pull complete 
    11. 9017140fb8c1: Pull complete 
    12. b76dda2673ae: Pull complete 
    13. bea9eb46d12a: Pull complete 
    14. e1f050a38d0f: Pull complete 
    15. Digest: sha256:7345ce4ce6f0c1771d01fa333b8edb2c606ca59d385f69575f8e3e2ec6695eee
    16. Status: Downloaded newer image for mysql:latest
    17. docker.io/library/mysql:latest
    19. docker images
    20. REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
    21. mysql               latest              c8ee894bd2bd        11 days ago         456MB
    23. docker run --name wtp-mysql -p 33006:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:latest
    24. 821eed795a6671c2d0abe0a715317f3a537f77f6179f95a674ce399ed0248656
    26. # --name: 容器名字 
    27. # -p 容器暴漏的端口 
    28. # 33006:3306 外部的33006对应容器内部的3306端口
    29. # -e 容器的环境变量
    30. # -d 容器后台运行

    这个时候我们使用navicat连接一下看看
    image.png
    Test Connection出错：
    image.png
    权限验证规则不能加载，我们进入容器看看

    1. docker ps  
    2. CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                                NAMES
    3. 821eed795a66        mysql:latest        "docker-entrypoint.s…"   5 minutes ago       Up 5 minutes        33060/tcp, 0.0.0.0:33006->3306/tcp   wtp-mysql
    5. docker exec -it wtp-mysql /bin/bash
    6. # docker exec ：在运行的容器中执行命令
    7. # -i 即使没有附加也保持STDIN 打开
    8. # -t 分配一个伪终端
    9. root@821eed795a66:/# ls
    10. bin  boot  dev    docker-entrypoint-initdb.d  entrypoint.sh  etc    home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  tmp  usr  var
    11. mysql -u root -p
    12. Enter password: 
    13. Welcome to the MySQL monitor.  Commands end with ; or \g.
    14. Your MySQL connection id is 11
    15. Server version: 8.0.18 MySQL Community Server - GPL
    17. Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
    19. Oracle is a registered trademark of Oracle Corporation and/or its
    20. affiliates. Other names may be trademarks of their respective
    21. owners.
    23. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    25. mysql> show databases;
    26. +--------------------+
    27. | Database           |
    28. +--------------------+
    29. | information_schema |
    30. | mysql              |
    31. | performance_schema |
    32. | sys                |
    33. +--------------------+
    34. 4 rows in set (0.00 sec)
    36. mysql> use mysql;
    37. Reading table information for completion of table and column names
    38. You can turn off this feature to get a quicker startup with -A
    40. Database changed
    41. mysql> show tables;
    42. +---------------------------+
    43. | Tables_in_mysql           |
    44. +---------------------------+
    45. | columns_priv              |
    46. | component                 |
    47. | db                        |
    48. | default_roles             |
    49. | engine_cost               |
    50. | func                      |
    51. | general_log               |
    52. | global_grants             |
    53. | gtid_executed             |
    54. | help_category             |
    55. | help_keyword              |
    56. | help_relation             |
    57. | help_topic                |
    58. | innodb_index_stats        |
    59. | innodb_table_stats        |
    60. | password_history          |
    61. | plugin                    |
    62. | procs_priv                |
    63. | proxies_priv              |
    64. | role_edges                |
    65. | server_cost               |
    66. | servers                   |
    67. | slave_master_info         |
    68. | slave_relay_log_info      |
    69. | slave_worker_info         |
    70. | slow_log                  |
    71. | tables_priv               |
    72. | time_zone                 |
    73. | time_zone_leap_second     |
    74. | time_zone_name            |
    75. | time_zone_transition      |
    76. | time_zone_transition_type |
    77. | user                      |
    78. +---------------------------+
    79. 33 rows in set (0.00 sec)
    80. ### 查看root用户的密码验证规则，修改一下
    81. mysql> select `plugin` from user where User='root';
    82. +-----------------------+
    83. | plugin                |
    84. +-----------------------+
    85. | caching_sha2_password |
    86. | caching_sha2_password |
    87. +-----------------------+
    88. 2 rows in set (0.00 sec)
    90. mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
    91. Query OK, 0 rows affected (0.01 sec)

    这个时候我们再进行navicat连接测试下
    image.png
    这样我们就可以访问容器里面的mysql数据库了。