/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

0 vote235 views1 answer
Sql get year from datetime field
SQL
3 votes264 views1 answer
Sql double index
SQL
1 vote237 views3 answers
How to truncate foreign key constraint table
SQL
13 votes232 views5 answers
Sql default
SQL
18 votes215 views3 answers
Mysql current date
SQL
-2 votes239 views2 answers
Union vs union all in sql
SQL
103 votes369 views1 answer
Like sql
SQL
3 votes242 views3 answers
Postgresql random number
SQL
2 votes261 views1 answer
Get the mysql table columns data type mysql
SQL
1 vote250 views1 answer
Date in where on datetime column clause mysql
SQL