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
不经一番彻骨寒,哪有梅花扑鼻香?
原文地址:https://www.cnblogs.com/zongyao/p/13831090.html