distal-attribute
distal-attribute
distal-attribute
distal-attribute

Unable to connect to remotely

User, date Message
Written by orbee
7 years ago
Category: Creating a connection
1 posts since Sat, 19 Jan 08
Hi,

I'm trying to connect remotely to my database and I'm getting the following error messages:

#1
"Could not establish connect! Details:

SQL ERROR: Lost Connection to MySql server during query."


#2
"Could not establish connect! Details:

SQL ERROR: Can't connect to MySql server on '....' (10060)"

The reason why I put 2 error messages is because my MySql server provider isn't exactly clear on which host name to use. So I tried both and here are the error messages that I received. Any insight as to what is going on is greatly appreciated.

Thanks
Written by siMKin
7 years ago
104 posts since Sun, 01 Apr 07
Did you read

this: http://www.heidisql.com/forum/viewtopic.php?t=238
this: http://www.heidisql.com/forum/viewtopic.php?t=247
and this: http://dev.mysql.com/doc/refman/5.1/en/access-denied.html
?
Written by Eric Pement
6 years ago
1 posts since Tue, 18 Nov 08

orbee wrote: I'm trying to connect remotely to my database and I'm getting the following error messages:

#1
"Could not establish connect! Details:

SQL ERROR: Lost Connection to MySql server during query."


In a case I handled today, this error message occurred because /tmp directory on the server with MySQL was not world-writeable. Only root had write-access to the /tmp directory. (Don't know why!)

The Heidi SQL Error message was too vague, and I would never have known what was really at fault, had I not also tried to connect with MySQL Query Browser, which gave me this more informative error message: "Can't create/write to file '/tmp/#sql ..."

That was the clue. I changed /tmp to world-read/write/execute, and the problem resolved immediately.

HTH.
 

Please login to leave a reply, or register at first.