How to solve the problem of database date error before importing mysql5.x to mysql5.7 !, Mysql5.xmysql5.7

How to solve the problem of database date error before importing mysql5.x to mysql5.7 !, Mysql5.xmysql5.7

 

How to solve the problem of database date error before importing mysql5.x to mysql5.7!

Modify the configuration file of mysql5.7 as follows:

Linux: Find the installation path of mysql to enter the default/usr/share/mysql/, edit the my-default.cnf

Use the search function "/" to find "SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES"

Delete or annotate it.

Windows: Find the mysql installation path in 32-Bit mode and directly modify the my. ini file using ctrl + f

The searched content should be SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

Comment it out or delete it.

In the 64-bit windows hidden folder C: \ ProgramData \, locate MySQL \ MySQL Server 5.7 and modify the configuration file my. ini.

The content searched by ctrl + f should be SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

Comment it out or delete it.