一开始 使用下面的命令启动MySQL:
docker run -p3306: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=123456 -d mysql
:latest
报错信息如下:
mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2023-05-25T15:22:19.029043Z 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
2023-05-25T15:22:19.031675Z 0 [ERROR] [MY-010119] [Server] Aborting
解决方法是:
在命令后面加上宿主机对应地址:
-v /mydata/mysql/mysql-files:/var/lib/mysql-files
完整命令是:
docker run -p3306: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=123456 -d mysql:latest
成功启动