Docker镜像中安装mysql容器

1. mysql 源码包下载
下载链接： https://dev.mysql.com/downloads/mysql/ ， 选择合适的版本下载，这里选择 mysql-5.7.26.tar.gz
tar -xvf mysql-5.7.26.tar.gz

2. 这里指记录下自己在docker中安装mysql成功的dockerfile

FROM nvidia/cuda:9.2-cudnn7-runtime-ubuntu18.04

#换一个源更新
ADD sources.list /root/sources.list
RUN cp /root/sources.list /etc/apt/sources.list.d/aliyun.list
RUN apt-get update && apt-get install -y make cmake gcc g++ bison libncurses5-dev build-essential

#ADD boost
ADD boost_1_59_0 /usr/local/boost

#安装mysql
ADD mysql-5.7.26 /root/mysql
WORKDIR /root/mysql
RUN mkdir build
WORKDIR build
RUN cmake .. -DWITH_BOOST=/usr/local/boost -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLETION=utf8_bin -DENABLED_LOCAL_INFILE=1 -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DMYSQL_TCP_PORT=3306
RUN make
RUN make install

RUN groupadd mysql
RUN useradd -g mysql mysql
RUN chown -R mysql:mysql /usr/local/mysql

RUN echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
# RUN source /etc/profile
# 安装脚本必须在/usr/local/mysql目录下执行，因为里面会使用相对路径调用其他脚本
WORKDIR /usr/local/mysql
RUN mkdir /usr/local/mysql/data && chmod 777 /usr/local/mysql/data
# 5.7以上的版本只能使用mysqld设置初始化参数
RUN /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --collation-server=utf8_general_ci
COPY testdb.sql /usr/local/mysql/data

EXPOSE 3306
CMD