构建包含mysql和redis服务的docker镜像

直接上dockerfile代码

FROM centos:centos7.9.2009
RUN yum install -y wget && \
    wget https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm && \
    yum -y localinstall mysql80-community-release-el7-11.noarch.rpm && \
    rm mysql80-community-release-el7-11.noarch.rpm && \
    yum-config-manager --disable mysql80-community && \
    yum-config-manager --enable mysql57-community && \
    yum -y install mysql-community-server && \
    sed -i '/^PIDFile=\/var\/run\/mysqld\/mysqld.pid/s/^/# /' /usr/lib/systemd/system/mysqld.service && \
    yum install -y epel-release && \
    yum install -y redis && \
    sed -i '/^bind 127.0.0.1/s/^/# /' /etc/redis.conf && \
    sed -i 's/protected-mode yes/protected-mode no/' /etc/redis.conf && \
    yum remove -y wget epel-release  && \
    yum clean all
COPY start.sh /start.sh
RUN chmod +x /start.sh
ENTRYPOINT ["/start.sh"]

启动脚本  start.sh，和dockerfile放在同一层路径下

#!/bin/bash

# 检查 MySQL 数据目录是否存在数据文件
if [ ! -f /var/lib/mysql/ibdata1 ]; then
    # 执行 MySQL 初始化
    mysqld --initialize --explicit_defaults_for_timestamp --user=mysql
    echo "MySQL initialized!"
    # 启动 MySQL 服务器
    echo "Starting MySQL server..."
    mysqld --user=mysql &

    sleep 5s
    if grep -q "A temporary password is generated" /var/log/mysqld.log; then
        # 获取初始密码
        initial_password=$(grep "A temporary password is generated" /var/log/mysqld.log | awk '{print $NF}')
        echo "Initial password: $initial_password"

        # 修改密码
        mysql -uroot -p"$initial_password" --connect-expired-password -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '1qaz2wsx';"
        if [ $? -eq 0 ]; then
            echo "Root password changed successfully!"
        else
            echo "Failed to change root password!"
            exit 1
        fi
        mysql -uroot -p1qaz2wsx --connect-expired-password <<EOF
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EOF
    fi
else
    # 启动 MySQL 服务器
    echo "Starting MySQL server..."
    mysqld --user=mysql &
fi

# 启动 Redis 服务器
echo "Starting Redis server..."
redis-server /etc/redis.conf &

echo "services started."

# 持续监听，保持容器运行
tail -f /dev/null

生成docker镜像

docker build -t mysql-redis .

启动docker容器

宿主机器的3306端口要转发给容器内的mysql服务监听端口，6379端口要转发给容器内的redis服务端口。

docker run -d --name mysql-redis -p 6379:6379 -p 3306:3306  mysql-redis:latest

启动的docker容器的redis服务已经设置了可以远程连接，mysql远程连接的root用户，密码root

接下去就可以用这个超级用户创建新的数据库了，例如

CREATE DATABASE IF NOT EXISTS new_database DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE USER 'new_user'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON new_database.* TO 'new_user'@'%';

注意把上面数据库名，密码等信息换成实际的