felito Posted July 3, 2011 Share Posted July 3, 2011 i am using the `vertigo serv`, and when i put `SET GLOBAL event_scheduler = ON;` in `my.conf` i get an error of `database 3306`. How can i fix this? thanks Link to comment https://forums.phpfreaks.com/topic/240979-set-global-event_scheduler-on-error-3306/ Share on other sites More sharing options...
fenway Posted July 3, 2011 Share Posted July 3, 2011 Huh? Link to comment https://forums.phpfreaks.com/topic/240979-set-global-event_scheduler-on-error-3306/#findComment-1237865 Share on other sites More sharing options...
gizmola Posted July 4, 2011 Share Posted July 4, 2011 Yeah there is no error 3306. We need to know what error is occurring. Link to comment https://forums.phpfreaks.com/topic/240979-set-global-event_scheduler-on-error-3306/#findComment-1238032 Share on other sites More sharing options...
felito Posted July 4, 2011 Author Share Posted July 4, 2011 port=3306, i simply edited my.ini, and then, i put the SET GLOBAL event_scheduler = ON inside of [mysqld] after this change the database connection stops to work Link to comment https://forums.phpfreaks.com/topic/240979-set-global-event_scheduler-on-error-3306/#findComment-1238036 Share on other sites More sharing options...
gizmola Posted July 4, 2011 Share Posted July 4, 2011 No, your my.ini should have this: event_scheduler=1 Running SET GLOBAL event_scheduler = ON is something you would do as the mysql root user in the mysql client of a running server to turn it on. However, if it's disabled in the my.cnf or my.ini, that won't work, until you change the configuration variable and restart mysqld. Link to comment https://forums.phpfreaks.com/topic/240979-set-global-event_scheduler-on-error-3306/#findComment-1238040 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.