创建并启动容器
docker run -p 3306:3306 --name mysql \
-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(改为你想要设置的mysql密码) \
-d mysql:8.0.16
mysql__Exited1_10">出现问题:mysql 容器的状态为 Exited(1)
docker_mysql__17">查看docker 启动mysql 的日志
日志中提示,没有/var/lib/mysql-files目录或文件
Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2024-04-27T01:55:52.298175Z 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
2024-04-27T01:55:52.303115Z 0 [ERROR] [MY-010119] [Server] Aborting
解决办法
需要加上-v /mydata/mysql/mysql-files:/var/lib/mysql-files ,用来对/var/lib/mysql-files 和宿主机的目录做映射
1.先停止容器
docker stop mysql(这里是容器名,或者容器id)
2.删除容器
docker rm mysql
3. 重新执行创建并启动容器的命令()
docker run -p 3306:3306 --name mysql \
-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(改为你想要设置的mysql密码) \
-d mysql:8.0.16