i am trying to use event scheduler in mysql database i new to programming and haven't done this before. when i type SET GLOBAL event_scheduler=ON; in the command line i get this message:
mysql> set global event_scheduler=on; ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation.
how do i resolve this issue? it is also possible to place my event scheduler code along with my server code or does it need to be done in the command line?
thank you