/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 vote122 views1 answer
Testing sql queries
SQL
2 votes175 views3 answers
Sql server reseed identity column
SQL
0 vote172 views1 answer
How to reset table in sql server
SQL
1 vote171 views1 answer
Oracle add proxy
SQL
1 vote132 views1 answer
Postgres division by zero
SQL
0 vote190 views1 answer
Mysql edit trigger
SQL
0 vote162 views3 answers
Sql parenthetical expression examples
SQL
5 votes170 views1 answer
Oracle scan source ddl
SQL
0 vote167 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
7 votes170 views1 answer
Minecraft forge server host
SQL