/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 vote286 views1 answer
Mysql workbench view
SQL
7 votes286 views1 answer
Oracle reset sequence
SQL
0 vote376 views1 answer
Sqlite display data in separated columns
SQL
0 vote264 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote293 views1 answer
Initcap in mysql
SQL
0 vote288 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote286 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote305 views1 answer
Ansi sql count duplicate rows
SQL
0 vote282 views1 answer
Create new schema mysql
SQL
0 vote318 views1 answer
Having all mysql
SQL