/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 vote138 views1 answer
Postgresql get current user name
SQL
0 vote137 views1 answer
Query on date sqlite flutter
SQL
0 vote151 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote144 views2 answers
How to combine diff colmun value using group by postgres
SQL
7 votes160 views2 answers
N highest salary in sql
SQL
13 votes149 views2 answers
Get tables in database sql
SQL
-1 vote156 views1 answer
Spring boot mysql connection properties
SQL
0 vote172 views1 answer
Sql select first and last record of each group
SQL
1 vote154 views3 answers
Reset sql primary key
SQL
0 vote142 views1 answer
SQL column name Oracle
SQL