Unable to connect to remotely
| User, date | Message |
|---|---|
|
Written by orbee
5 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
5 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
5 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: 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. |