centos7+docker +mysql配置远程连接笔记(解決mysql导入数据时出现Err 1067：Invalid default value for 'xxx')

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',''));