/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 vote366 views1 answer
Mysql where in keep order
SQL
3 votes334 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote409 views1 answer
Create a plsql object
SQL
0 vote358 views1 answer
Null column as zero in mysql
SQL
6 votes402 views3 answers
Create database mysql utf8
SQL
0 vote389 views1 answer
Nodejs sql get one to many relationship as array
SQL
5 votes342 views1 answer
Oracle find foreign key dependencies
SQL
0 vote385 views1 answer
Basic structure of sql expression having clause
SQL
-1 vote349 views1 answer
Mysql #1064 error
SQL
0 vote348 views1 answer
Power bi dax add related shows column but not working
SQL