【Mysql】into outfile报错的问题明明有select 权限却报错
mysql> select * from server into outfile '/tmp/tt.txt';
ERROR 1045 (28000): Access denied for user 'chenliang'@'%' (using password: YES)

MySQL 5.7 Invalid default value for 'CREATE_TIME'报错的解决方法由于数据库的升级，今天在执行从MySQL 5.6导出来的SQL文件时报错:

mysql> source cms_user.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warni