Events not working db

Events are run by the scheduler, which is not started by default.
mysql> SHOW PROCESSLIST;
The event_scheduler is running, but it doesn't appear in the list. For me it's better to use
mysql> select @@event_scheduler;
OR, you can also verify using the following command:
mysql> SELECT @@global.event_scheduler;
The result should be ON, otherwise set it off (will get 0 for the command), as stated in the next section
If you don't have any such entry (as above), you may start the event scheduler using the following command:
mysql> SET GLOBAL event_scheduler = ON;

Similar codes

22 votes218 views2 answers
Mysql show all tables
SQL
0 vote228 views1 answer
Order by in codeigniter query builder
SQL
0 vote225 views1 answer
Postpresql relation not found
SQL
0 vote221 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
-1 vote234 views1 answer
How to change the auto increment in existing table mysql
SQL
4 votes221 views2 answers
Mysql how to change default charset
SQL
1 vote219 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote264 views10 answers
Sql statement checker corrector
SQL
17 votes239 views4 answers
Sort by mysql
SQL
1 vote244 views2 answers
Foreign key set 0
SQL