MySQL Socket Error

ID:1126983
 
Jan 16 2013, 11:29 am
(See the best response by Nadrew.)
Code:
http://www.byond.com/developer/DivineTraveller/ MySQLmobsaving

^ the library

Problem description:
No connection to the database, good luck saving. (Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))


Any help would be appreciated im not sure what is wrong.. MySQL works fine on the web but i can't get it to work in game im using a 64bit os but i have copied the 32 bit mysql client libarries to lib32 and everything
Jan 16 2013, 11:52 am
Best response
Sounds like your host doesn't allow non-local MySQL connections (not many do).
Jan 16 2013, 11:58 am (Edited on Jan 16 2013, 12:07 pm)
im using a vps i have control over mysql configuration and also the connection is local.
Jan 16 2013, 12:15 pm
If you are using linux you'll need to open the MySQL port which by default is 3306, the port is closed for a security reasons.

You can open it using iptables.

You will also need to allow the MySQL account that you are using to be able to connect from any host.

And edit the my.cnf file

Here's a nifty guide - http://www.cyberciti.biz/tips/ how-do-i-enable-remote-access-to-mysql-database-server.html

[EDIT] If you are hosting DreamDaemon on the same server it shouldn't need the above, I would assume your login credentials are incorrect or you are connection incorrectly.
Jan 16 2013, 12:21 pm
The credentials are correct and it is local from the server

http://puu.sh/1OBUW

I have tested via my webserver and it connects fine im not sure why its not working with DreamDaemon.
Jan 16 2013, 12:22 pm
oh hey i got it to work i think lol testing now.