1,参考https://yeasy.gitbooks.io/docker_practice/install/centos.html 安装docker
2,参考https://www.runoob.com/docker/docker-install-mysql.html 安装mysql
进入mysql进行操作docker exec -it mysql5719 bash (mysql5719是容器名)
输入mysql -u root -p,再输入mysql密码
mysql -u root –p
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
mysql>ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';(解决
Authentication plugin 'caching_sha2_password' cannot be loaded错误
)
记得需要配置好centos7的防火墙
解決mysql导入数据时出现Err 1067:Invalid default value for 'xxx'
方案:去掉 sql_mode,global.sql_mode 中的 values: NO_ZERO_IN_DATE,NO_ZERO_DATE 即可
脚本:
set @@global.sql_mode=(select replace(@@global.sql_mode,'NO_ZERO_IN_DATE,NO_ZERO_DATE',''));
set sql_mode=(select replace(@@sql_mode,'NO_ZERO_IN_DATE,NO_ZERO_DATE',''));