Docker 安装 MySQL

1. 下载镜像

   docker pull mysql:5.7
   

2. 创建实例并启动

   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=123456 -d mysql:5.7
   

   • -p 3306:3306 指将容器的3306端口映射到主机（虚拟机）的3306端口
   • -v /mydata/mysql/log:/var/log/mysql 指将docker容器中的日志文件夹挂载到主机（虚拟机）
   • -e MYSQL_ROOT_PASSWORD=root 指初始化root用户的密码

3. 配置主机MySQL

   vi /mydata/mysql/conf/my.cnf
   
   [client] 
   default-character-set=utf8
   
   [mysql] 
   default-character-set=utf8
   
   [mysqld]
   init_connect='SET collation_connection = utf8_unicode_ci' 
   init_connect='SET NAMES utf8'
   character-set-server=utf8 
   collation-server=utf8_unicode_ci 
   skip-character-set-client-handshake
   skip-name-resolve
   

• skip-name-resolve: 跳过域名解析

Notion文章链接