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

Unable to connect to remotely

orbee posted 7 years ago in Creating a connection
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
siMKin posted 7 years ago
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
?
Eric Pement posted 6 years ago

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.