linux使用docker搭建mysql8.0.32环境并开放远程(一次成功)

自己在服务器上搭建mysql环境找了好多教程都不成功。记录一下过程

1.安装docker环境

curl -fsSL get.docker.com -o get-docker.sh   //获取脚本
sh get-docker.sh    //执行脚本安装docker
systemctl start docker  //启动

2.配置mysql

1.拉取

docker pull mysql:8.0.32

2.挂载路径创建（路径随意）

mkdir -p /usr/local/app/mysql/conf
mkdir -p /usr/local/app/mysql/data
mkdir -p /usr/local/app/mysql/logs

3.创建mysql 配置文件

vim /usr/local /app/mysql/conf/my.cnf

[mysqld]
init-connect="SET collation_connection=utf8mb4_0900_ai_ci"
init_connect="SET NAMES utf8mb4"
skip-character-set-client-handshake
host_cache_size=0
skip-name-resolve
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
secure-file-priv=/var/lib/mysql-files
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/var/run/mysqld/mysqld.sock
!includedir /etc/mysql/conf.d

4.开放挂载路径访问权限

chmod -R 777 /usr/local/app/mysql/

5.运行

docker run --name mysql -v /usr/local/app/mysql/logs:/var/log/mysql -v /usr/local/app/mysql/data:/var/lib/mysql -v /usr/local/app/mysql/conf:/etc/mysql/conf.d -p 3348:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:8.0.32

6.开发远程访问

docker exec -it xxx sh 

mysql -u root -p

alter user 'root'@'%' identified by '123456' password expire never;
alter user 'root'@'%' identified with mysql_native_password by '123456';
flush privileges;