/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 vote118 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote102 views1 answer
Oracle sql count occurrences of value in column
SQL
4 votes110 views2 answers
Sql vs mysql
SQL
0 vote109 views1 answer
Select a row include list of array with join table SQL
SQL
3 votes127 views2 answers
Postgresql select all column names
SQL
1 vote122 views1 answer
Flask sqlalchemy default value
SQL
1 vote151 views1 answer
Oracle drop chain step
SQL
0 vote125 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote108 views1 answer
How to connect pgadmin with excel
SQL
1 vote119 views1 answer
Top 10 rows in mysql
SQL