mysql5.7常见问题配置整理
1、查看定时任务是否开启
show VARIABLES LIKE '%event_scheduler%';
set global event_scheduler =1;
2、查看大小写敏感是否打开
SHOW VARIABLES where Variable_name like 'lower%';
3、查看分组
SELECT @@global.sql_mode;
4、查看字符集
SHOW VARIABLES WHERE variable_name LIKE '%character%' OR variable_name LIKE '%collation%' ;
以上问题可修改my.cnf文件,重启后永久生效,最终的my.cnf文件如下:
[client]
default-character-set = utf8
[mysql]
default-character-set = utf8
[mysqld]
lower_case_table_names=1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
character_set_server = utf8
event_scheduler=1
保存后执行重启生效。
service mysqld restart