【菜鸟教程】CentOS Docker 安装
https://www.runoob.com/docker/centos-docker-install.html
Docker Dockerfile
https://www.runoob.com/docker/docker-dockerfile.html
mysqldump备份文件
查询所有的备份文件,导出sql文件
mysqldump -h127.0.0.1 -P3306 -uroot -p123456 --databases dbName --set-gtid-purged=OFF --triggers --routines --events > dbName.sql
恢复备份文件
mysql -h127.0.0.1 -P3306 -uroot -p123456 dbName < dbName.sql
mysql注意事项
error:The server requested authentication method unknown to the client
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;
nginx https