环境-docker安装mysql、设置开机启动mysql

r囧r小猫 2022-11-06 14:00 237阅读 0赞

[https://blog.csdn.net/weixin\_39947101/article/details/106560261?ops\_request\_misc=%257B%2522request%255Fid%2522%253A%2522161533809816780269845314%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request\_id=161533809816780269845314&biz\_id=0&utm\_medium=distribute.pc\_search\_result.none-task-blog-2~all~first\_rank\_v2~rank\_v29-1-106560261.pc\_search\_result\_hbase\_insert&utm\_term=docker%E5%AE%89%E8%A3%85mysql+%E5%BC%80%E5%90%AF%E8%87%AA%E5%8A%A8%E5%90%AF%E5%8A%A8][https_blog.csdn.net_weixin_39947101_article_details_106560261_ops_request_misc_257B_2522request_255Fid_2522_253A_2522161533809816780269845314_2522_252C_2522scm_2522_253A_252220140713.130102334.pc_255Fall._2522_257D_request_id_161533809816780269845314_biz_id_0_utm_medium_distribute.pc_search_result.none-task-blog-2_all_first_rank_v2_rank_v29-1-106560261.pc_search_result_hbase_insert_utm_term_docker_E5_AE_89_E8_A3_85mysql_E5_BC_80_E5_90_AF_E8_87_AA_E5_8A_A8_E5_90_AF_E5_8A_A8]

10、环境-docker安装mysql、设置开机启动mysql

zouxuhang 2020-08-05 21:22:30 799 收藏 5  
分类专栏： 谷粒商城 docker mysql  
版权  
1.镜像仓库搜索mysql  
官方地址

https://hub.docker.com/  
1

2.拉取最新镜像

3.拉取指定版本镜像  
docker pull mysql:版本号  
例如：

docker pull mysql:5.7  
1  
4.查看下载镜像  
docker images  
1  
5.创建实例并启动

docker run -p 3306:3306 --name mysql \\  
\-v /mydata/mysql/log:/var/log/mysql \\  
\-v /mydata/mysql/data:/var/lib/mysql \\  
\-v /mydata/mysql/conf:/etc/mysql \\  
\-e MYSQL\_ROOT\_PASSWORD=root \\  
\-d mysql:5.7  
  
6.查看启动中容器  
docker ps  
1  
7.进行mysql容器，证明是一个完整独立的运行环境  
docker exec -it 容器id或容器名称 /bin/bash

docker exec -it mysql /bin/bash

whereis mysql  
1  
2  
3  
4  
5  
8.docker容器文件挂载与端口映射

/etc/mysql：mysql配置文件目录  
/var/log/mysql：mysql日志文件目录  
/var/lib/mysql：mysql数据文件

9.修改mysql配置文件

vi /mydata/mysql/conf/my.cnf  
1  
\[client\]  
\# 设置mysql客户端默认字符集  
default-character-set=utf8

\[mysql\]  
default-character-set=utf8

\[mysqld\]  
\#设置3306端口  
port=3306  
\# 设置mysql的安装目录  
\#basedir=E:\\05install\\mysql\\mysql-5.7.19-winx64  
\# 设置mysql数据库的数据的存放目录  
\#datadir=E:\\05install\\mysql\\mysql-5.7.19-winx64\\data  
\# 允许最大连接数  
max\_connections=200  
init\_connect='SET collation\_connection = utf8\_unicode\_ci'  
init\_connect='SET NAMES utf8'  
\# 服务端使用的字符集默认为8比特编码的latin1字符集  
character-set-server=utf8  
\#collation-server=utf8\_general\_ci  
collation-server=utf8\_unicode\_ci  
\# 创建新表时将使用的默认存储引擎  
default-storage-engine=INNODB  
\# 免密码登陆  
\# skip-grant-tables  
skip-character-set-client-handshake  
\#解决mysql连接慢的问题  
skip-name-resolve

10.重启mysql  
docker restart mysql  
1  
可以进入容器，查看容器中mysql配置文件也会存在

11.设置开机启动mysql  
docker update mysql --restart=always  
————————————————  
版权声明：本文为CSDN博主「zouxuhang」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。  
原文链接：https://blog.csdn.net/zouxuhang/article/details/107824441

[https_blog.csdn.net_weixin_39947101_article_details_106560261_ops_request_misc_257B_2522request_255Fid_2522_253A_2522161533809816780269845314_2522_252C_2522scm_2522_253A_252220140713.130102334.pc_255Fall._2522_257D_request_id_161533809816780269845314_biz_id_0_utm_medium_distribute.pc_search_result.none-task-blog-2_all_first_rank_v2_rank_v29-1-106560261.pc_search_result_hbase_insert_utm_term_docker_E5_AE_89_E8_A3_85mysql_E5_BC_80_E5_90_AF_E8_87_AA_E5_8A_A8_E5_90_AF_E5_8A_A8]: https://blog.csdn.net/weixin_39947101/article/details/106560261?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522161533809816780269845314%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=161533809816780269845314&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_v2~rank_v29-1-106560261.pc_search_result_hbase_insert&utm_term=docker%E5%AE%89%E8%A3%85mysql+%E5%BC%80%E5%90%AF%E8%87%AA%E5%8A%A8%E5%90%AF%E5%8A%A8