/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

2 votes99 views1 answer
Oracle current date without time
SQL
0 vote134 views1 answer
Use where instead of join
SQL
2 votes128 views2 answers
Postgresql date at timezone
SQL
1 vote135 views1 answer
Sql eliminare un record
SQL
0 vote170 views1 answer
Mysql get hour from datetime
SQL
8 votes210 views1 answer
Oracle search code in packages
SQL
0 vote169 views1 answer
Sql query to find percentage of null values in a table
SQL
5 votes149 views1 answer
Oracle list packages
SQL
0 vote138 views1 answer
Sql server select record with max id
SQL
3 votes165 views3 answers
Order by postgres
SQL