Docker 安装 mysql8.0

1

cat /etc/docker/daemon.json

1
2
3
4
5

{
  "registry-mirrors": [
    "https://registry.docker-cn.com"
  ]
}

1
2
3
4
5

{
  "registry-mirrors": [
    "https://hub-mirror.c.163.com"
  ]
}

1

systemctl restart docker

1

docker info | grep Mirrors -A 1

1
2
3

mkdir -p mysql8.0/{conf,data} # conf 存放配置文件,data 存放数据库文件
touch mysql8.0/conf/my.cnf # 创建配置文件
chown -R 999:999 mysql8.0 # 修改权限

1
2
3
4
5

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= /var/lib/mysql

1
2
3
4
5
6
7

docker run -d \
    -p 3310:3306 \
    --name mysql8.0 \
    -v /root/weibin/mysql8.0/conf/my.cnf:/etc/mysql/my.cnf \
    -v /root/weibin/mysql8.0/data:/var/lib/mysql \
    -e MYSQL_ROOT_PASSWORD=123456 \
    mysql:8.0

1

-v /root/dockerdata/mysql/docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d

1

docker exec -it 容器ID bash

1

update user set host='%' where user = 'root';

1

flush privileges;

1

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

1

Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files