/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

3 votes134 views6 answers
Jwt laravel
SQL
0 vote105 views1 answer
Sql max min
SQL
0 vote109 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
0 vote95 views1 answer
Sql from null to not null
SQL
0 vote113 views1 answer
Mysql extract day from date leading zero
SQL
4 votes120 views3 answers
NOT NULL SQL
SQL
0 vote100 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote102 views1 answer
Mysql command line top 10
SQL
8 votes104 views1 answer
Sql remove leading spaces
SQL
0 vote102 views1 answer
Mod function example
SQL