网站的需求,渠道建设网站,三类人不适合学编程,大同住房和城乡建设网站学习并记录一下如何用docker部署MySQL
在Docker中搜索并下载MySQL8.0.x的最新版本 下载好后#xff0c;在Images中就可以看到MySQL的镜像了 通过下面的命令也可以查看docker images启动镜像#xff0c;使用下面的命令就可以启动镜像了docker run -itd --name mysql8.0.34 -…学习并记录一下如何用docker部署MySQL
在Docker中搜索并下载MySQL8.0.x的最新版本 下载好后在Images中就可以看到MySQL的镜像了 通过下面的命令也可以查看docker images启动镜像使用下面的命令就可以启动镜像了docker run -itd --name mysql8.0.34 -p 3306:3306 --privilegedtrue -e MYSQL_ROOT_PASSWORDroot mysql:8.0.34解释 -i 即使没有连接也要保持标准输入保持打开状态一般与 -t 连用-t分配一个伪tty一般与 -i 连用-d在后台运行容器并且打印容器id–name镜像名称-p端口映射容器内端口3306映射到容器外的3306上–privileged为容器提供权限-e设置镜像参数 MYSQL_ROOT_PASSWORD设置root用户的密码 此时在容器内部已经初始化好了MySQL了但是一般来说我们需要把MySQL的配置文件和datadir挂在到docker外部所以我们还需要后面的步骤创建config和data目录mkdir -p /Users/xxx/docker/data/mysql8.0.34/{config,data}切换到config目录cd /Users/xxx/docker/data/mysql8.0.34/config把config文件从镜像内部复制出来docker cp mysql8.0.34:/etc/my.cnf ./确认config文件cat my.cnf# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size 128M
# sort_buffer_size 2M
# read_rnd_buffer_size 2M# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-pluginmysql_native_password
skip-host-cache
skip-name-resolve
datadir/var/lib/mysql
socket/var/run/mysqld/mysqld.sock
secure-file-priv/var/lib/mysql-files
usermysql
# 忽略表名大小写
lower_case_table_names1pid-file/var/run/mysqld/mysqld.pid
[client]
socket/var/run/mysqld/mysqld.sock!includedir /etc/mysql/conf.d/停掉并删除之前启动的MySQL镜像docker stop mysql8.0.34
docker rm mysql8.0.34重启MySQLdocker run -itd --name mysql8.0.34 -p 3306:3306 --privilegedtrue --restartalways -v /Users/xxx/docker/data/mysql8.0.34/data:/var/lib/mysql -v /Users/xxx/docker/data/mysql8.0.34/config/my.cnf:/etc/my.cnf -e MYSQL_ROOT_PASSWORDroot mysql:8.0.34使用连接工具测试MySQL
