/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 vote178 views7 answers
Les jointures sql server
SQL
1 vote185 views1 answer
Mysql how to reset primary key
SQL
1 vote205 views1 answer
Create new index takes long time postgresql
SQL
2 votes178 views1 answer
Sql update from different table
SQL
0 vote274 views1 answer
Show mysql account privilleges
SQL
1 vote186 views1 answer
How to group by month using sql server
SQL
0 vote204 views1 answer
Postgres regex word boundary
SQL
1 vote169 views1 answer
Sql server 2012 query history
SQL
0 vote190 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote254 views2 answers
Return the number of records in a single table mysql
SQL