/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 vote286 views1 answer
How to list function in psql
SQL
0 vote267 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote270 views1 answer
Mysql pv progres
SQL
6 votes281 views1 answer
Postgres get size of database
SQL
1 vote279 views1 answer
Postgres convert date to string
SQL
0 vote287 views1 answer
Multiple like values for single column postgres
SQL
1 vote284 views1 answer
Select tables with name like mysql
SQL
0 vote310 views1 answer
Insert into table with only identity column
SQL
1 vote266 views1 answer
Sample in sql
SQL
0 vote282 views2 answers
Cambiar nombre tabla mysql
SQL