问题1:Variable ‘sql_mode’ can’t be set to the value of ‘NO_AUTO_CREATE_USER’
解决:
a、是用navicat打开命令窗口(工具->控制台窗口)
b、查看配置,修改配置(注意:与Linux环境有所差异)
SELECT @@global.sql_mode;
mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
谢谢大家,多多指教!!!