/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 vote217 views1 answer
Postgresql create user roles
SQL
8 votes214 views3 answers
Alter user root mysql
SQL
0 vote224 views1 answer
Select sql in descending order
SQL
58 votes414 views6 answers
Create new user in postgres
SQL
4 votes220 views5 answers
Primary key
SQL
0 vote219 views1 answer
Sql #region
SQL
6 votes237 views4 answers
Mysql group by date
SQL
0 vote201 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote231 views1 answer
Get current date data in mysql
SQL
-1 vote222 views1 answer
How to change the auto increment in existing table mysql
SQL