Would you like to learn how to enable the MySQL event scheduler? In this tutorial, we are going to show you how to enable the MySQL event scheduler on a computer running Ubuntu Linux.

• Ubuntu 18.04
• Ubuntu 19.04
• MySQL 8.0.18

Equipment list

The following section presents the list of equipment used to create this tutorial.

As an Amazon Associate, I earn from qualifying purchases.

Tutorial MySQL – Enabling the Event Scheduler

Access the MySQL command-line.

Copy to Clipboard

Enable the MySQL scheduler.

Copy to Clipboard

Verify the status of the MySQL scheduler.

Copy to Clipboard

Here is the command output:

Copy to Clipboard

To permanently enable the MySQL scheduler, you need to edit the configuration file named: mysqld.cnf

Copy to Clipboard

Add the following line under the Mysqld area.

Copy to Clipboard

Here is our configuration.

Copy to Clipboard

Restart the MySQL service.

Copy to Clipboard

In our example, we enabled the MySQL scheduler permanently.