/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

4 votes140 views2 answers
How to count items with same name in sql
SQL
0 vote193 views1 answer
Postgres extract number from string
SQL
0 vote141 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote168 views1 answer
Sql tablo sp
SQL
0 vote146 views2 answers
Zsh: command not found: mysq
SQL
25 votes140 views1 answer
Mysql grant all privileges to a user
SQL
0 vote138 views2 answers
Functions with parameters SQL
SQL
1 vote154 views1 answer
How to group by month using sql server
SQL
2 votes172 views2 answers
Install postgresql
SQL
1 vote139 views1 answer
Mysql random limit 1
SQL