/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

21 votes340 views3 answers
Sql average
SQL
0 vote338 views1 answer
Get the Db column names from a SqlDataReader
SQL
1 vote388 views2 answers
Mysql limit offset
SQL
18 votes325 views2 answers
Sql comments
SQL
4 votes330 views1 answer
Postgresql show current database
SQL
3 votes396 views1 answer
Oracle undo tablespace schema
SQL
0 vote351 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote321 views1 answer
Sql min
SQL
3 votes326 views1 answer
Sql multiple column index
SQL
0 vote357 views1 answer
Sql get date from timestamp
SQL