docker mysql 报错_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