How do I see all MySQL events that are running on my database?

Don P picture Don P · Jan 29, 2012 · Viewed 49.9k times · Source

I have a MySQL database. I am running two MySQL EVENTs. I need to get rid of one. I don't remember it's name. What do I do?

Answer

user319198 picture user319198 · Jan 30, 2012

its simple SHOW EVENTS lists all of the events in the current schema

To see events for a specific schema, use the FROM clause. For example, to see events for the test schema, use the following statement:

SHOW EVENTS FROM test;