/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 vote230 views2 answers
What is 1=2 in sql
SQL
0 vote229 views1 answer
Show tables in cassandra cql
SQL
51 votes632 views6 answers
Installing mysql on ubuntu
SQL
1 vote210 views1 answer
Mysql not supported auth mode
SQL
0 vote197 views2 answers
Disallowed function mysql to_date()
SQL
1 vote198 views3 answers
Remove unique key from a table
SQL
0 vote237 views1 answer
Renommer schema sql
SQL
1 vote244 views1 answer
Sql select sum group by id laravel
SQL
0 vote193 views1 answer
How to check xampp mysql password
SQL
0 vote217 views2 answers
Insert data mysql with cmd
SQL