/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

60 votes537 views6 answers
Add column in sql
SQL
0 vote322 views1 answer
Mysql group by range
SQL
6 votes363 views4 answers
Mysql group by month
SQL
0 vote435 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote344 views1 answer
Sql server rtrim everything after character
SQL
0 vote298 views1 answer
Oracle sql date summer time
SQL
0 vote397 views1 answer
Intellij mysql set timezone
SQL
0 vote320 views1 answer
Sequelize postgresql schema
SQL
0 vote382 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote371 views2 answers
Pl sql auto increment
SQL