/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 vote244 views1 answer
T sql return on letters only
SQL
0 vote273 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote217 views1 answer
Oracle sql developer script output limit
SQL
5 votes226 views1 answer
Alter table default value mysql
SQL
0 vote271 views1 answer
Install squirrel sql ubuntu
SQL
3 votes303 views2 answers
Synonym oracle
SQL
0 vote296 views1 answer
Add super privilege mysql
SQL
11 votes240 views2 answers
Sql between date range
SQL
0 vote272 views1 answer
Mysql subdate
SQL
6 votes275 views3 answers
Update with inner join postgres
SQL