events - how to permanently activate/set the global event_scheduler to 1 in mysql -


I have added an event to my mysql db and it works fine, but what makes me bother It is that every now and then I have to set mysql global variable 1 so that my event is active. I log in as a root user and I have full privileges (I use it for practice purposes)

Mysql server I have to execute the following line every time I log in

  __set global event_scheduler = 1__  

can I permanently set event_scheduler variables 1? I am using mysql 5.1.50 - Community

Yes, type event_scheduler = on in the default mysql config file somewhere under the [mysqld] section, usually /etc/my.cnf


Comments