I have Plesk via GoDaddy and I am the sole admin and user. When I go to phpMyAdmin and try to execute the following:

SET GLOBAL event_scheduler = 'ON'

I get the error "#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation"

Considering I don't have the tab for security how can I change the sql database privileges to allow this? It would be easy to do if it was local hosted but I can't find anything on how to do this with my specific setup.

  • Is the user name for admin "root" or "admin"?? – Rick James Jul 15 at 22:09
  • If the hosting is shared you probably can't get SUPER privileges and it is unlikely that they would enable the scheduler. – Dave Jul 16 at 11:57
  • The admin user name is my username so for this example lets say its 'bectalFTP'. So the only way around that is to host on my workstation? – littlecoder Jul 16 at 12:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.