Requires SUPER permissions

[cdwiegand]

Apparently this requires SUPER permission on the mysql host as line 22 of connect-mysql.js has connection.query('SET GLOBAL event_scheduler = 1'); which doesn't work for a non-SUPER user.

[nlf]

This can be worked around by setting the option cleanup: false which will keep the module from attempting to schedule the event cleanup, and bypassing the need for SUPER permission. It does, however, mean that stale sessions will not be removed.

[scottgonzalez]

@nlf Would you accept a patch that changes how cleanup works so that it just does the scheduling in node? It shouldn't create a performance issue since the time spent in node will just be initiating the query, and all the work will happen outside of the event loop anyway. If you'd accept that, I'll file an issue for it and start working on a patch.

[nlf]

Sure, that's a reasonable workaround. I would suggest keeping cleanup optional, however. And the user should be able to decide between having the job in mysql or having it run in node.

[scottgonzalez]

If you want to keep the current implementation as an option, I'd suggest having it try to use the mysql job, and if that fails, check the error code. If it failed because of ER_SPECIFIC_ACCESS_DENIED_ERROR, then use the node job. Boolean cleanup option would continue to exist.

[nlf]

Seems reasonable to me.