Quick Solution to database date error after mysql5.x is upgraded to mysql5.7, mysql5.xmysql5.7
The solution for database date errors before mysql5.x is upgraded to mysql5.7 is as follows:
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.
The above is a quick solution to database date errors after mysql5.x is upgraded to mysql5.7 and imported to mysql5.7. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!