/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

1 vote364 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote350 views1 answer
Empty table sqlite
SQL
3 votes375 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote381 views1 answer
Sql create and grant user access to database
SQL
1 vote363 views1 answer
Create new index takes long time postgresql
SQL
1 vote396 views1 answer
Show databases mysql docker
SQL
1 vote356 views1 answer
Postgres get month name from date
SQL
-1 vote332 views1 answer
Mysql coalesce
SQL
2 votes359 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote370 views1 answer
Sql today at midnight
SQL