docker下安装并启动mysql8容器,状态为Exited(1) * seconds ago

创建并启动容器

docker run -p 3306:3306 --name mysql \
-v /mydata/mysql/log:/var/log/mysql \
-v /mydata/mysql/data:/var/lib/mysql \
-v /mydata/mysql/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root(改为你想要设置的mysql密码) \
-d mysql:8.0.16

出现问题：mysql 容器的状态为 Exited(1)

查看docker 启动mysql 的日志

日志中提示，没有/var/lib/mysql-files目录或文件

 Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2024-04-27T01:55:52.298175Z 0 [ERROR] [MY-010095] [Server] 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
2024-04-27T01:55:52.303115Z 0 [ERROR] [MY-010119] [Server] Aborting

解决办法

需要加上-v /mydata/mysql/mysql-files:/var/lib/mysql-files ，用来对/var/lib/mysql-files 和宿主机的目录做映射

1.先停止容器

docker stop mysql(这里是容器名，或者容器id)

2.删除容器

docker rm mysql

3. 重新执行创建并启动容器的命令（）

docker run -p 3306:3306 --name mysql \
-v /mydata/mysql/log:/var/log/mysql \
-v /mydata/mysql/data:/var/lib/mysql \
-v /mydata/mysql/conf:/etc/mysql \
-v /mydata/mysql/mysql-files:/var/lib/mysql-files \
-e MYSQL_ROOT_PASSWORD=root(改为你想要设置的mysql密码) \
-d mysql:8.0.16

4. 启动容器成功

MySQL 容器状态变为up