/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 vote308 views1 answer
Mariadb errno 121
SQL
4 votes315 views2 answers
Linq join
SQL
0 vote341 views1 answer
Creating sqeuence in oracle database
SQL
0 vote324 views3 answers
CONTACT FORM SQL
SQL
0 vote308 views1 answer
Mysql milliseconds
SQL
3 votes317 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote254 views1 answer
Mysql insert with foreign key
SQL
0 vote289 views1 answer
Sql where time stamp is in between
SQL
2 votes299 views1 answer
Possgress drop if exists table
SQL
0 vote291 views1 answer
Rows, INSERT INTO, Returning with alias
SQL