/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 vote142 views1 answer
Sql show founctions
SQL
4 votes177 views2 answers
Mysql alter table set column unique
SQL
1 vote141 views1 answer
Change table to innodb mysql
SQL
1 vote145 views1 answer
Query for all indexes in table postgres
SQL
0 vote146 views1 answer
Hotw to alter lengh character vayng postgres
SQL
2 votes127 views1 answer
Pandas to sql index
SQL
0 vote132 views1 answer
Low level operator in dbms
SQL
1 vote171 views1 answer
Mysql tables max count
SQL
15 votes140 views2 answers
Sql order by multiple columns
SQL
0 vote127 views1 answer
Online sql testing tool
SQL