This is a example for connect mysql and socket.io without express
this example run good if you follow yhe next steps:
first: run de database db.sql in mysl two: Change the user in the connection with mysql in the file app.js and change the password three: Install the node_modules mysql and socket.io four: change the ip in inde.html and main.js for ip of your computer or can put localhost:3100!!! five: run the project!!!! node app :D
me find in http://fotogena.co like @sonickseven or to here if have some questions :)