小知识：Windows/Mac系统Docker方式安装Mysql(包含utf8)

目录 一、Mac系统下Docker安装 二、Win 10系统下Docker安装 三、安装Mysql

bcdedit /set hypervisorlaunchtype off

docker info docker version docker ps docker images docker run hello-world

docker run –restart=always –name mysql8.0 -p 3306:3306 -v ~/soft/mysql/datadir:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=**** -d mysql:8.0.12 –character-set-server=utf8mb4 –collation-server=utf8mb4_unicode_ci

$ docker ps

# # NOTE: THIS DOCKERFILE IS GENERATED VIA “apply-templates.sh” # # PLEASE DO NOT EDIT IT DIRECTLY. # # 系统使用 debian 的 buster-slim 镜像 FROM debian:buster-slim # 设置 uft8 环境 RUN apt-get update && apt-get install -y locales && rm -rf /var/lib/apt/lists/* && localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8 ENV LANG en_US.utf8 # 添加 mysql 的用户和组 RUN groupadd -r mysql && useradd -r -g mysql mysql RUN apt-get update && apt-get install -y –no-install-recommends gnupg dirmngr && rm -rf /var/lib/apt/lists/* # 添加 gosu，以便从 root 用户轻松降级，更详细可见 https://github.com/tianon/gosu/releases ENV GOSU_VERSION 1.12 RUN set -eux; savedAptMark=”$(apt-mark showmanual)”; apt-get update; apt-get install -y –no-install-recommends ca-certificates wget; rm -rf /var/lib/apt/lists/*; dpkgArch=”$(dpkg –print-architecture | awk -F- “{ print $NF }”)”; wget -O /usr/local/bin/gosu “https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch”; wget -O /usr/local/bin/gosu.asc “https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch.asc”; export GNUPGHOME=”$(mktemp -d)”; gpg –batch –keyserver hkps://keys.openpgp.org –recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4; gpg –batch –verify /usr/local/bin/gosu.asc /usr/local/bin/gosu; gpgconf –kill all; rm -rf “$GNUPGHOME” /usr/local/bin/gosu.asc; apt-mark auto “.*” > /dev/null; [ -z “$savedAptMark” ] || apt-mark manual $savedAptMark > /dev/null; apt-get purge -y –auto-remove -o APT::AutoRemove::RecommendsImportant=false; chmod +x /usr/local/bin/gosu; gosu –version; gosu nobody true RUN mkdir /docker-entrypoint-initdb.d RUN apt-get update && apt-get install -y –no-install-recommends # for MYSQL_RANDOM_ROOT_PASSWORD pwgen # for mysql_ssl_rsa_setup openssl # FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db: # File::Basename # File::Copy # Sys::Hostname # Data::Dumper perl # install “xz-utils” for .sql.xz docker-entrypoint-initdb.d files xz-utils && rm -rf /var/lib/apt/lists/* RUN set -ex; # gpg: key 5072E1F5: public key “MySQL Release Engineering <mysql-build@oss.oracle.com>” imported key=”A4A9406876FCBD3C456770C88C718D3B5072E1F5″; export GNUPGHOME=”$(mktemp -d)”; gpg –batch –keyserver ha.pool.sks-keyservers.net –recv-keys “$key”; gpg –batch –export “$key” > /etc/apt/trusted.gpg.d/mysql.gpg; gpgconf –kill all; rm -rf “$GNUPGHOME”; apt-key list > /dev/null # 添加 mysql 环境变量 ENV MYSQL_MAJOR 8.0 ENV MYSQL_VERSION 8.0.22-1debian10 RUN echo “deb http://repo.mysql.com/apt/debian/ buster mysql-8.0” > /etc/apt/sources.list.d/mysql.list # the “/var/lib/mysql” stuff here is because the mysql-server postinst doesn”t have an explicit way to disable the mysql_install_db codepath besides having a database already “configured” (ie, stuff in /var/lib/mysql/mysql) # also, we set debconf keys to make APT a little quieter 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-community-client=”${MYSQL_VERSION}” mysql-community-server-core=”${MYSQL_VERSION}” && rm -rf /var/lib/apt/lists/* && rm -rf /var/lib/mysql && mkdir -p /var/lib/mysql /var/run/mysqld && chown -R mysql:mysql /var/lib/mysql /var/run/mysqld # ensure that /var/run/mysqld (used for socket and lock files) is writable regardless of the UID our mysqld instance ends up having at runtime && chmod 1777 /var/run/mysqld /var/lib/mysql # 指定挂载点为 /var/lib/mysql，也可以通过 docker run -v 宿主机目录:容器中挂载点 VOLUME /var/lib/mysql # Config files COPY config/ /etc/mysql/ COPY docker-entrypoint.sh /usr/local/bin/ # backwards compat RUN ln -s usr/local/bin/docker-entrypoint.sh /entrypoint.sh # 作用类似于 CMD，但更加灵活复杂，使用后会将 CDM 的内容作为参数传给 ENTRYPOINT 指令 ENTRYPOINT [“docker-entrypoint.sh”] # 声明运行时暴露的端口（port1 port2 …）。但是在运行时并不会默认暴露这个配置的端口，还是需要 run 的时候指定， EXPOSE 3306 33060 CMD [“mysqld”]

docker build -t mysql-utf8:8.0.22 -f ./Dockerfile.debian .

docker run –name mysql8.0 -p 33307:3306 -v /u01/docker-mysql/datadir:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root用户密码 -d mysql-utf8:8.0.22 –character-set-server=utf8mb4 –collation-server=utf8mb4_unicode_ci