docker安装mysql启动状态变Exited_docker mysql exited

docker安装mysql启动后状态变Exited解决办法

mysql镜像下载安装完毕以后，执行以下命令启动mysql镜像

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 \
> -d mysql
1
2
3
4
5
6

如图所示启动后由Up状态立马变为Exited
此时查看日志：

docker logs --tail 50 --follow --timestamps mysql
1

图中报错日志如下：

2023-12-06T05:58:01.104333121Z mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2023-12-06T05:58:10.285907365Z 2023-12-06T05:57:59.672120Z 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
2023-12-06T05:58:12.195299235Z 2023-12-06 05:58:11+00:00 [ERROR] [Entrypoint]: Unable to start server.
1
2
3

此时发现问题，我们来修改启动命令：

docker run -p 3306:3306 --name mysql \
-v /mydata/mysql/log:/var/log/mysql \
-v /mydata/mysql/data:/var/lib/mysql-files \
-v /mydata/mysql/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql
1
2
3
4
5
6

如图完美启动，sex！

参数说明：
-p 3306:3306：将容器的 3306 端口映射到主机的 3306 端口
-v /mydata/mysql/conf:/etc/mysql：将配置文件夹挂载到主机
-v /mydata/mysql/log:/var/log/mysql：将日志文件夹挂载到主机
-v /mydata/mysql/data:/var/lib/mysql-files/：将配置文件夹挂载到主机
-e MYSQL_ROOT_PASSWORD=root：初始化 root