docker mysql8-Failed to access directory for --secure-file-priv

1.在配置文件my.cnf下增加如下

secure-file-priv= /var/lib/mysql

2.将此文件夹映射出来即可

-v /usr/local/mysql3308/mysql/mysql-files:/var/lib/mysql-files

docker run -p 3308:3306 --privileged=true --name mysql3308 -v /usr/local/mysql3308/mysql:/etc/mysql -v /usr/local/mysql3308/logs:/logs -v /usr/local/mysql3308/data:/var/lib/mysql -v /usr/local/mysql3308/mysql/mysql-files:/var/lib/mysql-files  -e MYSQL_ROOT_PASSWORD=root12 -d mysql:8.0.19