Error: “#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation”

K

kumkumsharma

Administrator
Staff member
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:
Login to cpanel >> Phpmyadmin >> Here click on particular database name >> Click on SQL tab and enter below line:

Code: 
'SET GLOBAL event_scheduler = ON;'
 
You must log in or register to reply here.
Top