/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 vote180 views1 answer
What is mysql_pconnect
SQL
0 vote184 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote179 views2 answers
Plsql regex match whole word
SQL
0 vote190 views1 answer
Sql delete from with relation
SQL
2 votes182 views2 answers
How to create an empty table from an existing table
SQL
3 votes195 views2 answers
Savepoint in sql
SQL
0 vote172 views1 answer
Online sql testing tool
SQL
0 vote189 views1 answer
Neo4j command to run script file
SQL
0 vote208 views1 answer
Sql int vs integer
SQL
0 vote190 views1 answer
Proc sql not in working
SQL