Docker中安装MySql5.7

Docker中MySQL5.7的安装步骤

1. 下载镜像

docker pull mysql:5.7

2. 宿主机创建MySQL所需目录

# 数据保存目录
mkdir -p /home/leo/docker-data/mysql/data/
# 日志保存目录
mkdir -p /home/leo/docker-data/mysql/logs/
# 配置文件
mkdir -p /home/leo/docker-data/mysql/conf/
# 在conf目录中创建my.cnf

[mysqld] 
port = 3306
character_set_server = utf8mb4
#log-error=/tmp/mysql/logs/error.log

# mysql的具体配置请参考MySQL官网

3. 启动命令

docker run -d --restart=unless-stopped -p 3306:3306 --privileged=true -v /home/leo/docker-data/mysql/conf:/etc/mysql/conf.d -v /home/leo/docker-data/mysql/data/:/var/lib/mysql -v /home/leo/docker-data/mysql/logs:/logs -e MYSQL_ROOT_PASSWORD=Yyf5211314! --name leo-mysql mysql:5.7

• –restart=unless-stopped docker启动后该镜像自动重启
• -v 挂载镜像目录
• –privileged=true 赋予root权限
• -p 3306:3306 映射宿主机端口

4. 修改管理员密码，创建远程登录用户并授权

• docker exec -it leo-mysql bash # 进入运行中的镜像

• use mysql

• alter user ‘root’@‘localhost’ identified by ‘Yyf5211314!’;

• create user ‘leo’@’%’ identified with mysql_native_password by ‘Yyf5211314!’;

• grant all privileges on . to ‘leo’@’%’;

• flush privileges

5. navicat 测试连接