/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 vote203 views1 answer
Mysql workbench view
SQL
4 votes239 views1 answer
Search column by name mysql
SQL
0 vote201 views3 answers
Above average salary in sql
SQL
1 vote270 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote200 views1 answer
Mysql query to add hours to column in table
SQL
1 vote193 views1 answer
Sql select all from one table and one column from another
SQL
1 vote194 views4 answers
Psql check tables command
SQL
-1 vote193 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
2 votes324 views2 answers
How to DROP a table in mysql
SQL
0 vote201 views1 answer
C# check if mysql query modified rows
SQL