1、MySQL 5.7 时间不兼容问题(Error : Invalid default value for 'last_login_time' )
这是通常是由于 MySQl 升级到 5.7+ 而引起的默认值不兼容的问题
mysql> select @@sql_mode;
+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| @@sql_mode |
+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| IGNORE_SPACE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
---------------------
NO_ZERO_IN_DATE, NO_ZERO_DATE 这两个参数限制时间不能为0
临时解决方法 :
mysql> set session sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
这种方式会在下次重新连接服务器时还是会出现上面那种问题,永久方案是直接修改 my.cnf 文件
vi /etc/my.cnf
在 [mysqld] 下面添加 :
sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
重启 MySQL
2、Table storage engine for 'supplier' doesn't have this option
ROW_FORMAT=FIXED不能用了,解决方法:删除 ROW_FORMAT=FIXED 即可
3、Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
解决方法:参考这篇文章(点我)添加相关权限
参考如下文章:
https://blog.csdn.net/chenshun123/article/details/79676567