docker启动mysql报错||docker ps没有容器,docker ps -a有发现断开了

 使用docker log 容器id查看报错日志

Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2020-08-24T07:46:16.964806Z 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
2020-08-24T07:46:16.968769Z 0 [ERROR] [MY-010119] [Server] Aborting

解决办法:

 在启动容器时 需要加上

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

例如我的:

docker run -p 3306:3306 --name mysql \
-v /home/mysql/mysql-files:/var/lib/mysql-files \
-v /mydata/mysql/log:/var/log/mysql \
-v /mydata/mysql/data:/var/lib/mysql \
-v /mydata/mysql/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:8.0.15

 

posted @ 2020-08-24 16:24  9529  阅读(1110)  评论(0编辑  收藏  举报