event_scheduler OFF

[azednetma]

Hi,

How to turn event_scheduler on ?

+-------------------+
| @@event_scheduler |
+-------------------+
| OFF |
+-------------------+

Thanks

 

[techAMIGO]

Hello,

you will have to open MySQL command line or MySQL client. Please verify if Event Scheduler is supported by your MySQL server.

#SHOW VARIABLES LIKE 'event_scheduler';

for Enabling the event_scheduler you can run the following command.

# SET GLOBAL event_scheduler = ON;

if you have to use it only for the current section you can run the below command.

# SET SESSION event_scheduler = ON;

After enabling the event_scheduler you can verify it by running the below command.

# SHOW VARIABLES LIKE 'event_scheduler';

 

[azednetma]

Issue resolved after installing zip and gd extensions!!