/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 vote343 views3 answers
Condition in count sql
SQL
18 votes314 views6 answers
Laravel form validation
SQL
3 votes316 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote331 views1 answer
Sql if clause within where clause
SQL
0 vote277 views0 answer
SQL
6 votes388 views2 answers
Install psql mac
SQL
0 vote318 views1 answer
Mysql terminal run sql file
SQL
5 votes328 views2 answers
Sql number columns
SQL
1 vote334 views3 answers
How to create a table structure from another table in mysql
SQL
13 votes310 views6 answers
Current date sql
SQL