1.下载mysql源码

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.20.tar.gz 

2.新建my.cnf文件

[client] port = 3306default-character-set=utf8socket = /usr/local/mysql/mysql.sock[mysql] port = 3306default-character-set=utf8socket = /usr/local/mysql/mysql.sock[mysqld] user = mysql basedir = /usr/local/mysql datadir = /usr/local/mysql/data port = 3306 character_set_server=utf8 pid-file = /usr/local/mysql/mysqld.pid socket = /usr/local/mysql/mysql.sock server-id = 1

3.新建dockerfile文件

FROM centos:7ADD mysql-boost-5.7.20.tar.gz /optWORKDIR /opt/mysql-5.7.20/RUN yum -y updateRUN yum -y install cmake ncurses ncurses-devel bison gcc gcc-c++ makeRUN useradd -s /sbin/nologin mysqlRUN cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DSYSCONFDIR=/etc/ -DSYSTEMD_PID_DIR=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DWITH_BOOST=boost -DWITH_SYSTEMD=1RUN make && make installRUN chown -R mysql:mysql /usr/local/mysql/RUN rm -rf /etc/my.cnfADD my.cnf /etcENV PATH /usr/local/mysql/bin:/usr/local/mysql/lib:$PATHWORKDIR /usr/local/mysqlRUN bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/dataRUN cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/EXPOSE 3306RUN echo -e "#!/bin/sh \nsystemctl enable mysqld" > /run.shRUN chmod 755 /run.shRUN sh /run.shCMD ["init"]

4.执行

build：docker build -t centos:mysql .运行：docker run --name=mysql_server -d -P --privileged mysql:centos进入容器：docker exec -it 容器id /bin/bash修改密码：mysql -u root -pEnter password: #此处直接回车grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘abc123‘;grant all privileges on *.* to ‘root‘@‘localhost‘ identified by ‘abc123‘;flush privilegesexit