【数据库-MySql】开启事件 event

xiaoxiao2021-02-28  7

Navicat Premium 事件计划已关闭。事件只能在服务器启动并开启事件计划时才能处理。

Navicat for MySQL The event_scheduler is Off. Events can be processed only when server is started with event_scheduler on

第一步、查看事件是否开启

SHOW VARIABLES LIKE 'event_scheduler';

第二步、开启事件

SET GLOBAL event_scheduler = ON; -- SET @@global.event_scheduler = ON; -- SET GLOBAL event_scheduler = 1; -- SET @@global.event_scheduler = 1;

关闭事件相关命令

SET GLOBAL event_scheduler = OFF; -- SET @@global.event_scheduler = OFF; -- SET GLOBAL event_scheduler = 0; -- SET @@global.event_scheduler = 0;

第三步、my.ini最后添加并保存

event_scheduler = 1第四步、重启MySQL服务
转载请注明原文地址: https://www.6miu.com/read-1750395.html

最新回复(0)