/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 vote213 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote222 views1 answer
Mysql Install Ubuntu with native password
SQL
1 vote216 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote198 views1 answer
Replace \n sql
SQL
0 vote251 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote208 views2 answers
Sql query in dax power bi
SQL
0 vote213 views1 answer
Sql server Cost Fifo query
SQL
15 votes215 views5 answers
If null mysql
SQL
0 vote197 views1 answer
Django mysqlclient connection string
SQL
2 votes204 views1 answer
Sql update alias
SQL