如何在Dockerfile中设置MySQL用户名

Question

在Ubuntu上使用apt-get install mysql-server安装MySQL时，会在安装过程中询问MySQL用户名和密码。

但是当使用Dockerfile构建MySQL镜像时，如何提供用户名和密码呢？

我尝试使用以下Dockerfile：

FROM ubuntu:14.04
apt-get update
apt-get install -y mysql-server

但是在构建镜像时，我发现我们可以在没有用户名和密码的情况下登录mysql。

当我使用dockerfile构建我的镜像时，如何设置用户名和密码？

- zcmyworld

Answer 1

如果您查看官方的Docker MySQL镜像Dockerfile，您会发现他们是如何使用debconf-set-selections完成的。

相关指令如下：

RUN { \
        echo mysql-community-server mysql-community-server/data-dir select ''; \
        echo mysql-community-server mysql-community-server/root-pass password ''; \
        echo mysql-community-server mysql-community-server/re-root-pass password ''; \
        echo mysql-community-server mysql-community-server/remove-test-db select false; \
    } | debconf-set-selections \
    && apt-get update && apt-get install -y mysql-server

`debconf-set-selections` 是一个工具，允许你在后续安装过程中预先设置问题的答案。

- Thomasleveil

---

谢谢！我发现这需要额外的一行，如此处所述。完整的、经过构建测试的示例在这里。 - senderle

Answer 2

tutumcloud/mysql

这是Dockerfile文件。

ADD run.sh /run.sh

ENV MYSQL_USER=admin \
    MYSQL_PASS=**Random** \
    ON_CREATE_DB=**False** \
    REPLICATION_MASTER=**False** \
    REPLICATION_SLAVE=**False** \
    REPLICATION_USER=replica \
    REPLICATION_PASS=replica

run.sh

StartMySQL ()
{
    /usr/bin/mysqld_safe ${EXTRA_OPTS} > /dev/null 2>&1 &
    # Time out in 1 minute
    LOOP_LIMIT=60
    for (( i=0 ; ; i++ )); do
        if [ ${i} -eq ${LOOP_LIMIT} ]; then
            echo "Time out. Error log is shown as below:"
            tail -n 100 ${LOG}
            exit 1
        fi
        echo "=> Waiting for confirmation of MySQL service startup, trying ${i}/${LOOP_LIMIT} ..."
        sleep 1
        mysql -uroot -e "status" > /dev/null 2>&1 && break
    done
}
CreateMySQLUser()
{
    if [ "$MYSQL_PASS" = "**Random**" ]; then
        unset MYSQL_PASS
    fi

    PASS=${MYSQL_PASS:-$(pwgen -s 12 1)}
    _word=$( [ ${MYSQL_PASS} ] && echo "preset" || echo "random" )
    echo "=> Creating MySQL user ${MYSQL_USER} with ${_word} password"

    mysql -uroot -e "CREATE USER '${MYSQL_USER}'@'%' IDENTIFIED BY '$PASS'"
    mysql -uroot -e "GRANT ALL PRIVILEGES ON *.* TO '${MYSQL_USER}'@'%' WITH GRANT OPTION"
    echo "=> Done!"
    echo "========================================================================"
    echo "You can now connect to this MySQL Server using:"
    echo ""
    echo "    mysql -u$MYSQL_USER -p$PASS -h<host> -P<port>"
    echo ""
    echo "Please remember to change the above password as soon as possible!"
    echo "MySQL user 'root' has no password but only allows local connections"
    echo "========================================================================"
}
StartMySQL
CreateMySQLUser

.....helpful for u

- sixbyte

---

总的来说，对于 mysql -uroot -e "GRANT ALL PRIVILEGES ON *.* TO '${MYSQL_USER}'@'%' WITH GRANT OPTION" 命令要非常小心。 - Drew

出于两个原因，你刚刚赋予了他们所有权限（这大概是你需要的唯一原因）...但同时，小心使用 WITH GRANT OPTION。 - Drew