Mysql Event Scheduler needs super privileges

2

Good morning, I have a website hosting in a company, I created a very simple system that through an event that runs of a certain time in a certain time and makes changes in the elements of the database (in this case it changes the field "state" whenever the expiration date has been exceeded), but when I click on the Event Shedule Status button on it it gives me a erro 1227 that says I do not have super previlleges . Is it possible to keep activating without having such privileges? is there any way to implement a gender system without needing these privileges? or do I have to contact the company? p.s: Is this common or is it some problem with this hosting company? I apologize for the ignorance in lodgings, but I do not have much experience with this. Thanks!

    
asked by anonymous 30.05.2015 / 14:07

1 answer

1

You need to have at least the privilege to execute the event in this schema, so you would have to run the command to give the privilege like this:

GRANT EVENT ON myschema.* TO jon@ghidora;
  

link

    
01.09.2015 / 19:36