/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 vote118 views1 answer
Oracle lock user
SQL
0 vote158 views1 answer
Alter owner in PostgreSQL
SQL
1 vote132 views1 answer
STOP message of how many rows affected sql
SQL
1 vote139 views1 answer
Join to find results not in another table
SQL
49 votes218 views6 answers
Install mysql ubuntu
SQL
0 vote133 views1 answer
Heidisql check how much space a row
SQL
0 vote177 views1 answer
Updating database in sql
SQL
0 vote126 views1 answer
Assign value to var in SQL
SQL
-2 votes182 views1 answer
Trunc in sql
SQL
7 votes141 views2 answers
N highest salary in sql
SQL