k8s记录-docker源码安装mysql5.7.20

1.下载mysql源码

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

2.新建my.cnf文件

[client]                            
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock
 
[mysql]                           
port = 3306
default-character-set=utf8
socket = /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:7
ADD mysql-boost-5.7.20.tar.gz /opt
WORKDIR /opt/mysql-5.7.20/
RUN yum -y update
RUN yum -y install \
cmake \
ncurses \
ncurses-devel \
bison \
gcc gcc-c++ \
make
RUN useradd -s /sbin/nologin mysql
RUN 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=1
RUN make && make install
RUN chown -R mysql:mysql /usr/local/mysql/
RUN rm -rf /etc/my.cnf
ADD my.cnf /etc
ENV PATH /usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
WORKDIR /usr/local/mysql
RUN bin/mysqld \
--initialize-insecure \
--user=mysql \
--basedir=/usr/local/mysql/ \
--datadir=/usr/local/mysql/data
RUN cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
EXPOSE 3306
RUN echo -e "#!/bin/sh  \nsystemctl enable mysqld" > /run.sh
RUN chmod 755 /run.sh
RUN sh /run.sh
CMD ["init"]

nginx-14.2

FROM centos:7
RUN yum -y install vim net-tools bridge-utils firewalld bc iotop bc gcc gcc-c++ glibc glibc-devel pcre pcre-devel openssl openssl-devel zip unzip zlib-devel lrzsz tree ntpdate telnet lsof tcpdump wget libevent libevent-devel systemd-devel bash-completion traceroutepsmisc
RUN mkdir -p /data/projects/common/nginx
RUN useradd nginx -s /sbin/nologin -u 2000
ADD nginx-1.14.2.tar.gz /data/projects/common
RUN cd /data/projects/common/nginx-1.14.2 && ./configure --prefix=/data/projects/common/nginx --user=nginx --group=nginx --with-http_ssl_module --with-http_v2_module --with-http_realip_module --with-http_stub_status_module --with-http_gzip_static_module --with-pcre --with-stream --with-stream_ssl_module --with-stream_realip_module && make && make install && ln -sv /data/projects/common/nginx/sbin/nginx /usr/sbin/nginx
CMD ["nginx","-g","daemon off;"]
EXPOSE 80
EXPOSE 443

mysql5.6

FROM centos:7
RUN mkdir -p /data/projects/common/mysql
ADD mysql-5.6.20.tar.gz /data/projects/common
WORKDIR /data/projects/common/mysql-5.6.20/
RUN yum -y update
RUN yum -y install \
cmake \
ncurses \
ncurses-devel \
bison \
gcc gcc-c++ \
perl \
autoconf \
make
RUN useradd -s /sbin/nologin mysql
RUN cmake \
-DCMAKE_INSTALL_PREFIX=/data/projects/common/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DSYSTEMD_PID_DIR=/data/projects/common/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=/data/projects/common/mysql/data
RUN make && make install
RUN chown -R mysql:mysql /data/projects/common/mysql/
RUN rm -rf /etc/my.cnf
ADD my.cnf /etc
ENV PATH /data/projects/common/mysql/bin:/data/projects/common/mysql/lib:$PATH
WORKDIR /data/projects/common/mysql
RUN scripts/mysql_install_db --user=mysql --basedir=/data/projects/common/mysql/ --datadir=/data/projects/common/mysql/data
EXPOSE 3306
CMD ["/data/projects/common/mysql/bin/mysqld_safe"]

4.执行

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