1 基本的docker配置

    1. docker pull mysql

    2 核心配置

    1. docker run -d --restart on-failure -p 1998:3306 -v "/opt/dkmysql/data/":/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root98322@ --name dkrmysql mysql:latest --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

    3 进入和配置数据库

    1. docker exec -it dkrmysql /bin/bash
    4. mysql> create database CRM charset=utf8;
    5. Query OK, 1 row affected, 1 warning (0.01 sec)
    7. mysql> create user crm identified by 'crm123';
    8. Query OK, 0 rows affected (0.05 sec)
    10. mysql> grant all on CRM.* to 'crm'@'%' with grant option;
    11. Query OK, 0 rows affected (0.01 sec)
    13. mysql> alter user 'crm'@'%' identified by 'crm123@' password expire never;
    14. Query OK, 0 rows affected (0.01 sec)
    16. mysql> alter user 'crm'@'%' identified with mysql_native_password by 'crm123@';
    17. Query OK, 0 rows affected (0.01 sec)
    19. mysql> flush privileges;
    20. Query OK, 0 rows affected (0.00 sec)
    22. mysql> exit
    23. Bye

    4 本地连接和导入
    image.png

    5 整体逻辑

    image.png

    6 主要参考教程

    1. 1. 远程访问
    2. https://zhuanlan.zhihu.com/p/394348387
    3. 2. 字符集处理以及安装Vim
    4. https://segmentfault.com/a/1190000037511682
    5. 3. Docker official MySQL
    6. https://hub.docker.com/_/mysql
    7. 4. 主从配置
    8. https://blog.csdn.net/weixin_40461281/article/details/115628334
    9. 5. docker compose方式
    10. https://zhuanlan.zhihu.com/p/384330120
    11. 7. C7 安装 compose
    12. https://bbs.huaweicloud.com/blogs/242272
    13. 8. MySQL官网 --- Docker 配置
    14. https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
    15. 9. Docker退出码
    16. http://www.xuyasong.com/?p=1802#Exit_Code_1