Docker启动mysql8.0版本自动退出，Supplied value : /var/lib/mysql-files

原创已于 2022-03-20 12:22:42 修改 · 3.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#docker #mysql

于 2022-03-20 12:04:35 首次发布

笔记专栏收录该内容

6 篇文章

订阅专栏

在尝试使用Docker运行MySQL容器时遇到容器自动退出的问题，原因是缺少'/var/lib/mysql-files'的挂载路径。通过查看日志发现错误信息，并解决了该问题。解决方案是在启动命令中添加一个新的挂载点，将宿主机的路径映射到'/var/lib/mysql-files'，重新启动容器后，问题得到解决，MySQL容器成功运行。

[root@xiao /]# docker run -d -p 3306:3306 -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 --name mysql mysql
a0cb6c6bf60baa45a79da19fee048b680cf306b4b4ed47b7bf05e693f52b759a
You have new mail in /var/spool/mail/root
[root@xiao /]# docker ps -a
CONTAINER ID   IMAGE     COMMAND                  CREATED         STATUS                     PORTS     NAMES
a0cb6c6bf60b   mysql     "docker-entrypoint.s…"   4 seconds ago   Exited (1) 2 seconds ago             mysql
[root@xiao /]# docker ps 
CONTAINER ID   IMAGE     COMMAND   CREATED   STATUS    PORTS     NAMES

发现容器自动退出

查看日志：docker logs mysql

[root@xiao /]# docker logs mysql
2022-03-20 03:51:20+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.27-1debian10 started.
2022-03-20 03:51:20+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-03-20 03:51:20+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.27-1debian10 started.
mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2022-03-20T03:51:21.229669Z 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
2022-03-20T03:51:21.229698Z 0 [ERROR] [MY-010119] [Server] Aborting

发现，日志报错，没有一个/var/lib/mysql-files挂载的真实路径

mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)

解决方法：添加一个对应的宿主机路径，在重新启动前，记得删除已经存在的容器

-v /mydata/mysql/mysql-files:/var/lib/mysql-files

这是本人成功截图

[root@xiao /]# docker run -d -p 3306:3306 -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 --name mysql mysql
83147b6cb0ff24d18ff5737a75b02ec33daa91a0556b72774ef84150abc5ad06
[root@xiao /]# docker ps
CONTAINER ID   IMAGE     COMMAND                  CREATED         STATUS         PORTS                                                  NAMES
83147b6cb0ff   mysql     "docker-entrypoint.s…"   3 seconds ago   Up 2 seconds   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql