dockerfile 部署mysql5.7.21 并随容器自启动(无持久卷版)-------docker-compose方式和持久卷后面补发

#环境说明，from centos7.5,mysql5.7.21

1.Dockerfile

#FROM    centos:7
#FROM    hub.c.163.com/public/centos:6.7-tools
FROM    makayel/supervisor
LABEL   maintainer='xxx' centos_version='7.5' mysql_version='5.7' 
RUN mkdir -p /home/install/mysql/
COPY    mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz /home/install/mysql
COPY    my.cnf /home/install/mysql
COPY    install-mysql5.7.sh home/install/mysql
RUN    yum install -y psmisc
RUN yum install -y ncurses-devel 
RUN yum install -y libaio
RUN yum install -y libaio-devel
RUN yum install -y iproute
RUN yum -y install numactl.x86_64
RUN echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile
RUN source /etc/profile

ENV     PATH /usr/local/mysql/bin:$PATH
EXPOSE  13307


#执行初始化脚本文件
#ENTRYPOINT ["/home/install/mysql/install-mysql5.7.sh"]

ENTRYPOINT /home/install/mysql/install-mysql5.7.sh && echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile && source /etc/profile && tail -f /dev/null
#CMD ["tailf /usr/local/mysql/logs/mysql.log >>/dev/null"]

2.install-mysql5.7.sh

#!/bin/bash
export LANG=en_US.UTF-8

INSTALL_PATH=$(pwd)
echo "当前目录:"+${INSTALL_PATH}

install_mysql(){

	echo "执行mysql安装>>>"
	echo "删除mysql相关配置文件并copy my.cnf到etc目录"
	rm -rf /etc/my.cnf
	rm -rf /etc/init.d/mysql
	cp /home/install/mysql/my.cnf /etc/my.cnf
	mkdir -p /usr/local/mysql/

	echo "创建mysql用户组和用户"
	groupadd mysql
	useradd -g mysql mysql

	echo "解压.tar.gz到指定文件夹下 /usr/local/mysql"
	tar -vxzf /home/install/mysql/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz -C /home/install/mysql/
	mv /home/install/mysql/mysql-5.7.21-linux-glibc2.12-x86_64/* /usr/local/mysql/

	echo "更改usr/local/mysql所属的组和用户"
	#cd /usr/local
	#USR_LOCAL=$(pwd)

	chown -R mysql /usr/local/mysql/
	chgrp -R mysql /usr/local/mysql/

	#cd mysql/
	echo "创建mysql数据目录/usr/local/mysql/data并设置目录权限"+$(pwd)
	mkdir -p /usr/local/mysql/data
	chown -R mysql:mysql /usr/local/mysql/data

	echo "创建mysql日志目录/usr/local/mysql/logs并设置目录权限"+$(pwd)
	mkdir -p /usr/local/mysql/logs
	touch /usr/local/mysql/logs/mysql.log
	touch /usr/local/mysql/logs/mysql-error.log
	chmod -R +x /usr/local/mysql/logs/*
	chown -R mysql:mysql /usr/local/mysql/logs
	chown -R mysql:mysql /usr/local/mysql/logs

	echo "设置mysql权限并初始化mysql"
	#cp ./support-files/mysql.server /etc/init.d/mysqld
	cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

	chown 777 /etc/my.cnf
	chmod a+x /etc/init.d/mysqld
	#/usr/local/mysql/bin/mysql_install_db   --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
	/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

	#echo "修改mysql环境变量>>>>>>>>>>>"
	#echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile
	#sleep 2
	#source /etc/profile

	#if [ $? -eq 0 ]; then
	#	 echo "配置mysql环境变量成功!"
	#else
	#	 echo "配置mysql环境变量失败!"
	#fi

	/etc/init.d/mysqld restart  
	sleep 5

	#service mysqld restart
	/etc/init.d/mysqld restart 
	sleep 5
	echo "mysql启动成功!"

	mysql -uroot -p123456


	echo "重新设置登录密码!"
	#service mysqld stop
	/etc/init.d/mysqld stop
	sleep 5
	echo -e '\nskip-grant-tables' >> /etc/my.cnf
	#service mysqld start
	/etc/init.d/mysqld start 
	sleep 5
	#service mysqld status
	/etc/init.d/mysqld status

	/usr/local/mysql/bin/mysql --connect-expired-password  -uroot -e "UPDATE mysql.user SET authentication_string=PASSWORD('123456') where USER='root';"
	/usr/local/mysql/bin/mysql --connect-expired-password  -uroot -e "FLUSH PRIVILEGES;"

	sed -i '/skip-grant-tables/d'  /etc/my.cnf
	echo "重新设置登录密码后重启mysql!"
	#service mysqld restart
	/etc/init.d/mysqld restart 
	sleep 5
	#service mysqld status
	/etc/init.d/mysqld status 
	/usr/local/mysql/bin/mysql --connect-expired-password  -uroot -p123456 -e "show databases;"
	echo "为mysql取消密码认证过期设置！"
	/usr/local/mysql/bin/mysql --connect-expired-password  -uroot -p123456 -e "alter user user() identified by '123456';"
	/usr/local/mysql/bin/mysql --connect-expired-password  -uroot -p123456 -e "show databases;"

	echo "为mysql开启root远程登录！"
	/usr/local/mysql/bin/mysql --connect-expired-password  -uroot -p123456 -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;"
	/usr/local/mysql/bin/mysql --connect-expired-password  -uroot -p123456 -e "FLUSH PRIVILEGES;"


	sleep 5

	echo "设置mysql开机自启!"
	chmod +x /etc/rc.d/init.d/mysqld
	chkconfig --add mysqld
	chkconfig --level 35 mysqld on


	echo "mysql重设后启动成功!!!!!!"

}



echo "判断mysql是否已经安装>>>>>>>>>>>"
if [ ! -d "/usr/local/mysql/bin" ]
then
	echo "mysql未安装,进行安装>>>"
	install_mysql
else
	#当/usr/local/mysql/bin目录存在，继续判断其中是否有mysql文件，如存在，则表示mysql已安装过
	if [ ! -f "/usr/local/mysql/bin/mysql" ]
	then
		echo "mysql未安装,进行安装>>>"
		install_mysql
	else
		echo "mysql已安装,启动mysql>>>"
		/etc/init.d/mysqld restart 
		exit 0 
	fi
fi

 

3.my.cnf

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8 
[mysqld]
skip-name-resolve
#设置3306端口
port = 3306 
# 设置mysql的安装目录
basedir=/usr/local/mysql
# 设置mysql数据库的数据的存放目录
datadir=/usr/local/mysql/data
# 设置mysql的日志目录
general-log=1
log-output=FILE
general-log-file=/usr/local/mysql/logs/mysql.log
log_error=/usr/local/mysql/logs/mysql-error.log
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB 
lower_case_table_names=1
max_allowed_packet=16M

 

4.docker built步骤  并运行

docker build --network=host -t mysql-centos7:5.7 --no-cache .

docker run --name mysql-centos7.5 -d  -p 13307:3306 mysql-centos7:5.7 

5.通过docker shell和portainer (前面文章讲过部署步骤)查看