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
不经一番彻骨寒,哪有梅花扑鼻香?