docker 安装mysql

199 阅读1分钟

docker 切换国内镜像源

#编辑 /etc/docker/daemon.json 

{
  "builder": {
    "gc": {
      "defaultKeepStorage": "20GB",
      "enabled": true
    }
  },
  "experimental": true,
  "features": {
    "buildkit": true
  },
  "insecure-registries": [
    "172.24.86.231"
  ],
  "registry-mirrors": [
    "https://dockerproxy.com",
    "https://mirror.baidubce.com",
    "https://ccr.ccs.tencentyun.com",
    "https://docker.m.daocloud.io",
    "https://docker.nju.edu.cn",
    "https://docker.mirrors.ustc.edu.cn"
  ],
  "log-driver":"json-file",
  "log-opts": {
    "max-size":"500m", 
    "max-file":"3"
  }
}


安装mysql8

# 拉去镜像
 docker pull mysql:8.0

启动mysql8

我们将创建一个 MySQL 8 容器,并挂载一个本地目录到容器中的 /var/lib/mysql,以确保 MySQL 数据持久化。

sudo mkdir -p /data/mysql
sudo chmod 777 /data/mysql
docker run --name mysql8  -e MYSQL_ROOT_PASSWORD="plusgo@2024."  -v /data/mysql:/var/lib/mysql  -p 3306:3306  -d mysql:8.0


docker exec -it 69b7d72f3dc6 /bin/bash

mysql -u root -p
 #如果报错 
 ALTER USER 'root'@'%' IDENTIFIED WITH 'mysql_native_password' BY 'zyld@123'; 
 FLUSH PRIVILEGES;