/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 vote313 views1 answer
Spark sql convert string to date
SQL
0 vote283 views1 answer
How to find top 3 salary in sql
SQL
0 vote311 views1 answer
Consulta alias con inner join
SQL
0 vote329 views1 answer
Insert value in identity
SQL
0 vote284 views1 answer
Python mysql executemany
SQL
9 votes283 views3 answers
Where in sql
SQL
1 vote307 views1 answer
ORA-01950
SQL
9 votes311 views5 answers
Laravel to sql
SQL
0 vote288 views1 answer
How to change mysql port in xampp
SQL
1 vote296 views1 answer
SQLite order random
SQL