mysql 部分命令

查询mysql安装路径
show variables like '%basedir%';
查询mysql日志配置
show variables like '%general_log%';
查询事件
show variables like 'event_scheduler'
开启事件配置
event_scheduler = 1
SET @@global.event_scheduler = ON;