/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

12 votes214 views5 answers
Sql primary key
SQL
0 vote205 views1 answer
Ansi sql count duplicate rows
SQL
0 vote216 views2 answers
Starting mysql service from mac
SQL
0 vote219 views1 answer
Mysql into outfile with headers
SQL
0 vote204 views2 answers
Oracle create chain rule
SQL
5 votes209 views4 answers
Upload database mysql command line
SQL
1 vote214 views1 answer
Tsql replace value in json
SQL
0 vote211 views1 answer
Window function to forward fill
SQL
5 votes260 views1 answer
Pl sql asynchronous procedure calls
SQL
1 vote199 views1 answer
Oracle finding duplicate records
SQL