mysql - How can alter an Event in phpMyAdmin -

mysql - How can alter an Event in phpMyAdmin -

i have have scheduled event alter. utilize mysql workbench not show information_schema edit events. trying utilize phpmyadmin alter event cant figure out.

i update event_definition from:

update user set user.account_status=false user.account_status = true , user.lastupdate < (now() - interval 2880 minute)

to

update user set user.account_status=false user.account_status = true , user.lastupdate < (now() - interval 60 minute)

the event name statusset

normally asking java questions please excuse me if have left out of import info give me answer. please help. give thanks you.

first of check privileges running show grants current_user;

i inquire whether using proper alter event syntax, error message on creating event, should check user's privileges if ip related (user@ip).

mysql phpmyadmin mysql-workbench