Docker中部署Mysql8数据库

心已赠人 2022-09-11 04:23 153阅读 0赞

# 场景 #

Docker中部署mysql数据库：

[Docker中部署mysql数据库\_BADAO\_LIUMANG\_QIZHI的博客-CSDN博客][Docker_mysql_BADAO_LIUMANG_QIZHI_-CSDN]

上面安装过mysql5.7，下面介绍安装Mysql8。

注：

博客：  
[BADAO\_LIUMANG\_QIZHI的博客\_CSDN博客][BADAO_LIUMANG_QIZHI_CSDN]  
关注公众号  
霸道的程序猿  
获取编程相关电子书、教程推送与免费下载。

# 实现 #

1、拉取镜像最新版

docker pull mysql:latest

2、创建映射目录并进行授权

mkdir -p /usr/mysql8/conf /usr/mysql8/data

chmod -R 755 /usr/mysql8/

3、创建配置文件

vim /usr/mysql8/conf/my.cnf

4、修改配置文件内容

[client]
    
    #socket = /usr/mysql8/mysqld.sock
    
    default-character-set = utf8mb4
    
    [mysqld]
    
    #pid-file        = /var/run/mysqld/mysqld.pid
    
    #socket          = /var/run/mysqld/mysqld.sock
    
    #datadir         = /var/lib/mysql8
    
    #socket = /usr/mysql8/mysqld.sock
    
    #pid-file = /usr/mysql8/mysqld.pid
    
    datadir = /usr/mysql8/data
    
    character_set_server = utf8mb4
    
    collation_server = utf8mb4_bin
    
    secure-file-priv= NULL
    
    # Disabling symbolic-links is recommended to prevent assorted security risks
    
    symbolic-links=0
    
    # Custom config should go here
    
    !includedir /etc/mysql8/conf.d/

5、启动容器

docker run  -d --name mysql8 -v /usr/mysql8/conf/my.cnf:/etc/mysql/my.cnf -v /usr/mysql8/data:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:latest

6、连接测试

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAQkFEQU9fTElVTUFOR19RSVpISQ_size_20_color_FFFFFF_t_70_g_se_x_16][]

[Docker_mysql_BADAO_LIUMANG_QIZHI_-CSDN]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/99213563
[BADAO_LIUMANG_QIZHI_CSDN]: https://blog.csdn.net/badao_liumang_qizhi
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAQkFEQU9fTElVTUFOR19RSVpISQ_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/788bab26a9be4e488cabbb9bb7a23c5a.png