/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 vote279 views1 answer
Mysql error 1452
SQL
14 votes312 views5 answers
Set password for postgres user ubuntu
SQL
0 vote220 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote277 views1 answer
Like sql for second letter of the family name
SQL
40 votes361 views4 answers
PostgreSQL add column
SQL
11 votes282 views2 answers
Insert date sql
SQL
0 vote301 views1 answer
How do I insert a blob in SQL?
SQL
1 vote263 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
2 votes259 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote253 views2 answers
Sqlite
SQL