You can follow below steps to resolve this error, this error occur while running query in phpmyadmin.
- First you need root access to resolve this error.
- With root access you can make changes in configuration file with below command:
Code:
vi /etc/my.cnf
- You have to add below line in this file:
Code:
event_scheduler = 1
- Now save this file.
- You can also enter below line in SQL tab:
Code:
'SET GLOBAL event_scheduler = ON;'