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 Quote 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? Quote 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. Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.