How to set global event_scheduler=ON even if MySQL is restarted?

Question

I want to set the event_scheduler global to ON even if MySQL is restarted; how can I achieve this?

SET GLOBAL event_scheduler = ON;

one way - you can set system variables, and use those variables whenever needed (http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html). — Suleman Ahmad, Nov 21 '13 at 04:52

score 49 · Answer 1 · edited Aug 30 '18 at 12:06

49

You can set

event_scheduler=ON

in my.ini or my.cnf file, then restart your server for the setting to take effect.

Once set event_scheduler will always remain ON no matter whether your server restarts.

edited Aug 30 '18 at 12:06

Christian Giupponi

7,408
11
68
113

answered May 06 '14 at 06:36

prem

3,348
1
25
57

1

On my case (Ubuntu 14.04.4 LTS), adding it to `/etc/mysql/my.cnf` did the trick, while adding it to `/etc/mysql/my.ini` did nothing. – cavpollo Nov 04 '16 at 21:11
1

On a Windows machine with MySQL 5.7, `event-scheduler=on` worked for me – Ananth Jun 02 '17 at 12:08
4

Make sure you add the setting into the proper section - it should go under `[mysqld]`. Otherwise the server won't be able to start... – AntonK Sep 25 '18 at 15:44
And of course you have to put it into the right file. I had two files, one `D:\MariaDB\my.ini` and one `D:\MariaDB\data\my.ini` . Not sure why but during the installation the latter one was the one which is used. – Anse Feb 26 '19 at 10:58
on an Amazon Linux AMI image, it worked by modifying the /etc/my.cfg file. Thanks! – Graph Jan 13 '20 at 22:40

score 31 · Answer 2 · answered May 28 '15 at 14:18

31

Open your /etc/mysql/my.ini file and add:

event_scheduler = on

under the [mysqld] section

(tested under mysql 5.5.35-0+wheezy1 - Debian)

answered May 28 '15 at 14:18

Francesco Borzi

56,083
47
179
252

3

In some linux distros, the file is under /etc/my.cnf – RonEskinder Sep 27 '16 at 16:10
1

Was necessary for me, using MariaDB, include the line inside the [mysqld] section as suggested. – Leopoldo Sanczyk Apr 28 '17 at 22:55
/usr/local/etc/mysql for FreeBSD – Alpha2k Feb 28 '18 at 12:32
Using MariaDB from RHSCL, the config file would be in **/etc/opt/rh/rh-mariadb103/my.cnf** (change 103 to your version) – zypA13510 Dec 03 '19 at 07:30
For MariaDB be aware the [mysqld] is required and doesn't work with [mysql], only [mysqld]. Tested in Raspbian – Leandro Bardelli Jan 27 '21 at 17:27

score 4 · Accepted Answer · answered Nov 21 '13 at 05:05

4

One Way - You can set your system variables and use those variables if there is any possibility to restart your mysql.

Here is link Using system variables in mysql

answered Nov 21 '13 at 05:05

Suleman Ahmad

2,025
4
28
43

3

"If you change a global system variable, the value is remembered and used for new connections until the server restarts. (To make a global system variable setting permanent, you should set it in an option file)" – mvmn Jan 21 '16 at 19:02

score 4 · Answer 4 · answered Jun 13 '17 at 06:36

4

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Add this line at the end of the file:

event_scheduler=ON

Than reboot and check if daemon is started after reboot:

Log into mysql bash:

mysql -u <user> -p

Than run the command:

SHOW PROCESSLIST;

Now you should see the event scheduler daemon in the list

answered Jun 13 '17 at 06:36

Roberts Lando

41
1

this worked at ubuntu 16.04 i wasnt able to edit the my.cnf file. – Erik van Berkum Nov 15 '18 at 08:57

score 3 · Answer 5 · edited Apr 21 '15 at 18:09

On our Windows Server 2012 system, none of these or any other solutions worked. Then I looked at the registry entry for start up:

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56

The trick, the evil, is ProgramData. It's not Program Files. Look in Program Files and you'll see a my-default.ini file, put there just to royally screw you up.

The trick is to find the path in the registry, which was for me: HKEY_LOCAL_MACHINE\SYSTEM\Services\MySQL56

How to set global event_scheduler=ON even if MySQL is restarted?

5 Answers5

Linked