Unable to connect to remotely

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

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
?

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.