导入sql文件报错，[Err] 1067 - Invalid default value for ‘update_time‘

[Err] 1067 - Invalid default value for ‘update_time’
MySQL版本不对应，我原为5.5版本，重装5.6就可以正常导入了。

重装MySQL

1. 停止服务
   
2. 卸载，删除C:\ProgramData下的MySQL文件夹，删除注册表（我自己使用的是geek，可以自动删除注册表）
   到官网：https://downloads.mysql.com/archives/community/，下载对应安装包，以管理员权限运行cmd，进入mysql的bin下

#安装mysql服务
D:\ap-MySQL\bin>mysqld -install
Service successfully installed.

#初始化，生成data文件夹
D:\ap-MySQL\bin>mysqld  --initialize-insecure
2022-05-06 16:39:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-05-06 16:39:21 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2022-05-06 16:39:21 0 [Note] mysqld (mysqld 5.6.51) starting as process 3780 ...

#启动mysql
D:\ap-MySQL\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

#登录
D:\ap-MySQL\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.51 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

#修改密码
mysql> set password for root@localhost = password('123456');
Query OK, 0 rows affected (0.00 sec)