Mysql5.7 Docker部署

最新推荐文章于 2025-03-27 22:48:04 发布

HiJohnnyBoy

最新推荐文章于 2025-03-27 22:48:04 发布

阅读量666

点赞数 2

文章标签： docker 容器运维

原文链接：https://blog.youkuaiyun.com/litaimin/article/details/123777018

版权

该文详细介绍了如何使用Docker部署MySQL5.7，包括创建目录、配置文件、启动容器、修改root权限，以及在宿主机上连接MySQL服务的方法，并提到了在云服务器环境下需要开放防火墙端口。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

思路：
1、创建相应目录
2、创建配置文间
3、运行容器
4、进入容器内部修改root登录权限
5、测试连接（如果是云服务器，需要在防火墙开通相应端口）

1、创建相应目录
mkdir -p /opt/mysql/{data,logs,conf}
chmod 777 /opt/mysql/logs -R
2、创建配置文件(文件内容已放最下面，直接复制即可)
vim /opt/mysql/conf/mysql.cnf

3、运行容器
docker run -d --name="mysql" -p3306:3306 -v /opt/mysql/conf/:/etc/mysql/conf.d -v /opt/mysql/data:/var/lib/mysql -v /opt/mysql/logs:/var/log -e MYSQL_ROOT_PASSWORD="123456"  mysql:5.7

4、进入容器内部修改root登录权限
docker exec -it mysql bash
mysql -h 127.0.0.1 -P 3306 -u root -uroot -p'123456'
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
mysql> flush privileges;

mysql.cnf

[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
datadir=/var/lib/mysql
 
socket=/var/lib/mysql/mysql.sock
 
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 
lower_case_table_names=1

如果想在宿主机连接mysql服务，可下载mysql客户端

yum -y install mysql
mysql -h 127.0.0.1 -P 3306 -uroot -p'123456'

原文链接：https://blog.youkuaiyun.com/litaimin/article/details/123777018