docker下修改mysql配置文件
2024-10-01 11:02:11
版权声明:本文为博主原创文章,转载注明地址:http://blog.csdn.net/wang704987562 https://blog.csdn.net/wang704987562/article/details/73460005
由于需要修改mysql的sql_mode,在命令行修改每次重启都会失效,因为修改docker下mysql的配置文件。
操作系统:centos7
docker版本:Docker version 17.05.0-ce, build 89658be
mysql版本:5.7.18
1.拉取镜像
docker pull mysql:5.7.18
2.列出镜像
[root@zk01 ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
mysql 5.7.18 e799c7f9ae9c 5 weeks ago 407MB
3.运行docker
docker run -d -p 3306:3306 --name mymysql -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7.18
4.列出正在运行的容器
[root@zk01 docker]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
e1066fe2db35 mysql:5.7.18 "docker-entrypoint..." 6 seconds ago Up 6 seconds 0.0.0.0:3306->3306/tcp mymysql
5.进入容器
docker exec -it e1066fe2db35 /bin/bash
6.查看配置文件
/etc/mysql/mysql.conf.d/mysqld.cnf
配置文件内容:
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
#log-error = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0
7.查看mysql的sql_mode
mysql> SELECT @@GLOBAL.sql_mode;
+-------------------------------------------------------------------------------------------------------------------------------------------+
| @@GLOBAL.sql_mode |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set
8.停止并删除容器
docker stop e1066fe2db35
docker rm e1066fe2db35
9.重新启动容器,指定数据目录和配置文件
docker run -d -p 3306:3306 -v /soft/mysql/my.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf -v /soft/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 --name mymysql mysql:5.7.18
10.查看sql_mode
mysql> SELECT @@GLOBAL.sql_mode;
+-------------------+
| @@GLOBAL.sql_mode |
+-------------------+
| |
+-------------------+
1 row in set
mysql> SELECT @@SESSION.sql_mode;
+--------------------+
| @@SESSION.sql_mode |
+--------------------+
| |
+--------------------+
1 row in set
最新文章
- 为什么不能访问django自带的索引页
- Note: This element neither has attached source nor attached Javadoc and hence no Javadoc could be found.
- springmvc集成shiro登录失败处理
- 笔记本win7共享WIFI
- Selenium介绍
- 【MySQL】TokuDB引擎初探(MySQL升级为Percona,MySQL升级为MariaDB)
- 28个你必须知道的HTML5的新特性,技巧以及技术
- scp 在不同主机之间数据传输
- BZOJ 1612: [Usaco2008 Jan]Cow Contest奶牛的比赛( floyd )
- Telephone Lines USACO 月赛
- centos6的安装
- 用python的TK模块实现猜成语游戏(附源码)
- 64. Minimum Path Sum(中等, 又做出一个DP题, 你们非问我开不开心,当然开心喽!^^)
- Codeforces Round #552 (Div. 3) F. Shovels Shop (前缀和预处理+贪心+dp)
- 1171: lfx捧杯稳啦!
- mysqlfrm初步使用
- SQL注入——SQL Injection
- Python scrapy爬取带验证码的列表数据
- 菜鸟入门【ASP.NET Core】4:在CentOS上安装.NET Core运行时、部署到CentOS
- 【SQLite】简单的基本使用步骤