MySql 的 Dockerfile 编写

#创建一个基于5.7.30版本的MySql
FROM mysql:5.7.30 

MAINTAINER don
EXPOSE 3306
LABEL version="0.1" description="Mysql服务器" by="don"

#设置免密登录
ENV MYSQL_ALLOW_EMPTY_PASSWORD yes

#将所需文件放到容器中
COPY /mysql/setup.sh /mysql/setup.sh #拷贝安装脚本
COPY /mysql/create_db.sql /mysql/create_db.sql #创建数据库
COPY /mysql/initial_data.sql /mysql/initial_data.sql #初始数据
COPY /mysql/privileges.sql /mysql/privileges.sql #设置密码和权限

#设置容器启动时执行的命令
CMD ["sh", "/mysql/setup.sh"]

SECURITY WARNING: You are building a Docker image from Windows against a non-Windows Docker host. All files and directories added to build context will have '-rwxr-xr-x' permissions. It is recommended to double check and reset permissions for sensitive files and directories.

REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
loamen-mysql        5.7                 4da21faea397        2 minutes ago       449MB
mysql               5.7.30              9cfcce23593a        4 weeks ago         448MB

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES
bd285ecb867a        loamen-mysql:5.7    "docker-entrypoint.s…"   4 seconds ago       Up 4 seconds        0.0.0.0:3306->3306/tcp, 33060/tcp   loamen-mysql

#!/bin/bash
set -e

#查看mysql服务的状态，方便调试，这条语句可以删除
echo `service mysql status`

echo '1.启动mysql...'
#启动mysql
service mysql start
sleep 3

echo `service mysql status`
echo '2.创建数据库...'
mysql < /mysql/create_db.sql
sleep 3
echo '2.创建数据库完毕...'


echo '3.开始导入数据...'
mysql < /mysql/initial_data.sql
echo '3.导入数据完毕...'

echo '4.修改mysql权限...'
mysql < /mysql/privileges.sql
sleep 3
echo '4.权限修改完毕...'

#sleep 3
echo `service mysql status`
echo 'mysql容器启动完毕,且数据导入成功'

tail -f /dev/null

USE mysql;
CREATE DATABASE IF NOT EXISTS spaceon_gms;

--使用默认数据库
USE mysql;
-- 创建一个名为loamen_demo的数据库
CREATE DATABASE IF NOT EXISTS loamen_demo;

--使用默认数据库
--不要忘记初始化到哪个数据库
USE loamen_demo;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

--其他数据库初始化脚本
...

use mysql;
SELECT host, user FROM user;

-- 将数据库的权限授权给root用户，密码为123456：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';

-- 刷新权限这一条命令一定要有：
flush privileges;