[Santi.]

Hi, I'm having this problem when trying to connect to mysql database located in a cloud server.
"Can't connect to local MySQL server through socket '/tmp/mysql.sock'"

I already tried to solve this by creating a symbolic link of mysql.sock in /tmp/ but it didn't work.

Any idea?

[Neuro Toxin]

Why not use the servers IP Address?

[asherkin]

Use "127.0.0.1" or the correct path to the socket file instead of "localhost" as the DB hostname.

[Santi.]

Originally Posted by asherkin Use "127.0.0.1" or the correct path to the socket file instead of "localhost" as the DB hostname.

I'm not in the same computer. I have my server in a dedicated server and the db un a cloud server

[Santi.]

Originally Posted by Neuro Toxin Why not use the servers IP Address?

I use it

[asherkin]

The error message you have posted indicates that "localhost" has been set at the "host" in the databases config.

[Santi.]

Originally Posted by asherkin The error message you have posted indicates that "localhost" has been set at the "host" in the databases config.

Handle kv = CreateKeyValues("");
	KvSetString(kv,"driver", "default"); // default is mysql
	KvSetString(kv,"host","ip of the cloud server"); // not localhost neither 127.0...
	KvSetString(kv,"port","mysqlport");
	KvSetString(kv,"database", "database");
	KvSetString(kv,"user", "user");
	KvSetString(kv,"pass", "password");

This is the config I use

[Santi.]

The connection is done, I can connect to the server by mysql workbench, and in the server I can do the first query but after the connection die