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
Post a Comment