/SQL/MySQL - Enabling the Event Scheduler

MySQL - Enabling the Event Scheduler

MySQL - Enabling the Event Scheduler
mysql -u root -p
SET GLOBAL event_scheduler = ON;
SHOW VARIABLES WHERE VARIABLE_NAME = 'event_scheduler';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| event_scheduler | ON    |
+-----------------+-------+
To permanently enable the MySQL scheduler, you need to edit the configuration file named: mysqld.cnf
nano /etc/mysql/mysql.conf.d/mysqld.cnf
Add the following line under the Mysqld area.
event_scheduler = on
Here is our configuration.
[mysqld]
event_scheduler = on
Restart the MySQL service.
service mysql restart
In our example, we enabled the MySQL scheduler permanently.

Source: techexpert.tips

Similar codes

22 votes133 views3 answers
Year format in date mysql
SQL
0 vote115 views1 answer
Postgresql create user roles
SQL
8 votes129 views2 answers
Safe update mode in mysql
SQL
0 vote141 views1 answer
"Hello User Name"
SQL
0 vote154 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote119 views1 answer
Oracle current timestamp insert statement
SQL
7 votes130 views1 answer
Oracle reset sequence
SQL
0 vote124 views1 answer
Const pool = mysql.createpool()
SQL
3 votes131 views2 answers
How to delete git repo locally
SQL
0 vote120 views1 answer
Mysql workbench view
SQL