拉取mysql,创建并启动实例
docker pull mysql:5.7
启动mysql镜像
docker run -p 3306:3306 --name mysql \
-v /mydata/mysql/log:/var/log/mysql \
-v /mydata/mysql/data:/var/lib/mysql \
-v /var/mydata/mysql/conf:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql:5.7
参数说明:
① -p 3306:3306:将容器的3306端口映射到主机的3306端口
② -v /mydata/mysql/conf:/etc/mysql:将配置文件夹挂载到主机
③ -v /mydata/mysql/log:/var/log/mysql:将日志文件夹挂载到主机
④ -v /mydata/mysql/data:/var/lib/mysql/:将配置文件夹挂载到主机
⑤ -e MYSQL_ROOT_PASSWORD=root:初始化root用户的密码为root
用docker ps查看mysql镜像是否启动
进入mysql容器
docker exec -it mysql bin/bash
配置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
参数解析:提高MySQL的连接速度 ===> skip-name-resolve:跳过域名解析
重启MySQL
docke restart mysql