/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 vote128 views1 answer
Query to insert image
SQL
0 vote100 views1 answer
Uuid sqlalcomany
SQL
1 vote96 views1 answer
Copy postgres table from one schema into another
SQL
0 vote110 views1 answer
How to put value in parameters in mysqldataadapter
SQL
3 votes109 views1 answer
Oracle apex call duration
SQL
1 vote65 views1 answer
Unique vs distinct sql
SQL
42 votes174 views6 answers
Install beautifulsoup
SQL
6 votes156 views2 answers
Database url postgres
SQL
0 vote122 views1 answer
To Create directory
SQL
0 vote90 views1 answer
Alter boolean column postgresql
SQL