Syntax
------

SHOW EVENTS [{FROM | IN} schema_name]
  [LIKE 'pattern' | WHERE expr]

Description
-----------

Shows information about Event Manager events (created with CREATE EVENT).
Requires the EVENT privilege. Without any arguments, SHOW EVENTS lists all of
the events in the current schema:

SELECT CURRENT_USER(), SCHEMA();
+----------------+----------+
| CURRENT_USER() | SCHEMA() |
+----------------+----------+
| jon@ghidora    | myschema |
+----------------+----------+

SHOW EVENTS\G
*************************** 1. row ***************************
         Db: myschema
        Name: e_daily
      Definer: jon@ghidora
     Time zone: SYSTEM
        Type: RECURRING
     Execute at: NULL
   Interval value: 10
   Interval field: SECOND
       Starts: 2006-02-09 10:41:23
        Ends: NULL
       Status: ENABLED
     Originator: 0
character_set_client: latin1
collation_connection: latin1_swedish_ci
 Database Collation: latin1_swedish_ci

To see the event action, use SHOW CREATE EVENT instead, or look at the
information_schema.EVENTS table.

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;

The LIKE clause, if present, indicates which event names to match. The WHERE
clause can be given to select rows using more general conditions, as discussed
in Extended Show.

URL: https://mariadb.com/kb/en/show-events/