/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 vote284 views1 answer
Make parameters nullable in sql server
SQL
0 vote241 views6 answers
Unique key in sql
SQL
0 vote257 views1 answer
Psql datestyle
SQL
57 votes437 views5 answers
How to create a new user in postgresql
SQL
0 vote247 views2 answers
Sql update top 100
SQL
0 vote252 views1 answer
Laravel eloquent get generated sql
SQL
0 vote245 views1 answer
Version and edition of SQL Server Database Engine
SQL
7 votes275 views1 answer
Oracle pagination query rownum
SQL
0 vote260 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote233 views1 answer
Is not null postgresql
SQL