/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

17 votes311 views2 answers
How to assign date field for table in mysql
SQL
0 vote335 views1 answer
How to use lower case in mysql
SQL
0 vote281 views2 answers
Jupyter notebook connect to database
SQL
0 vote332 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote345 views1 answer
Sql output select
SQL
21 votes295 views7 answers
Table drop if exist sql server
SQL
6 votes320 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote355 views1 answer
Oracle session statistics
SQL
0 vote327 views1 answer
Oracle merge insert if not exists
SQL
7 votes345 views1 answer
Alter sequence set current value oracle
SQL