/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 votes189 views1 answer
Get first n letter of department name in sql
SQL
1 vote190 views1 answer
Primary key with prefix sql
SQL
0 vote256 views1 answer
Sql server current time without date
SQL
4 votes261 views2 answers
DB::transaction
SQL
-1 vote191 views2 answers
How to display top 50 rows?
SQL
34 votes237 views6 answers
Install mysql client ubuntu
SQL
3 votes196 views1 answer
Sql cast to integer
SQL
15 votes206 views4 answers
Pl sql
SQL
3 votes200 views3 answers
Raw select laravel
SQL
0 vote193 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL