/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 vote322 views1 answer
Data types mysql vs postgresql
SQL
1 vote315 views1 answer
Check constraint to check if date greater than todays date
SQL
3 votes314 views3 answers
Sql current year
SQL
0 vote342 views1 answer
Mysql search like but first exact match
SQL
0 vote351 views1 answer
Drop index in sql
SQL
0 vote331 views1 answer
Double in sql server example
SQL
0 vote336 views1 answer
Postgresql using reserved word as column name
SQL
0 vote341 views2 answers
Drop tables from local table database postgres
SQL
1 vote381 views1 answer
How to set up a trigger in sql
SQL
11 votes333 views2 answers
Insert date sql
SQL