forums › forums › SQLyog › Using SQLyog › Uknown Host
- This topic is empty.
-
AuthorPosts
-
-
April 28, 2004 at 9:39 pm #8411alanhardingMember
Hi there,
I'm using SQLyog to connect to a remote database. I've confirmed all the connection parameters with my host and they have checked at their end that all is as it should be. However, when I try and connect using the details they confirmed I get the following error:
“Error No. 2005”
“Unknown MySQL Server Host 'xxxxx.oneandone.co.uk' (11004)”
Where xxxxx is my database.
They can't figure out why it's not connecting at OneandOne – does anyone here have any ideas?
Much appreciated!
Alan
-
April 29, 2004 at 1:02 am #15732RiteshMember
Correct me if I am wrong but I dont think you need to specify your database as part of the HOST address.
You only need to specify the IP or the host name of the computer in which your ISPs MySQL server is hosted.
I will suggest that you triple check it with your host.
-
May 4, 2004 at 8:40 am #15733alanhardingMember
Hey Ritesh,
Thanks for your reply, but I've sorted the problem out now… The host address I was specifying was correct (I know what you're saying though, I've never specified a host address as anything other than a straight IP, etc.) – what OneandOne failed to tell me (after four emails to their customer service team 😡 ) was that I can't connect straight to my DB using an SQL GUI from home…
I've got it figured now, cheers.
🙂
-
May 31, 2004 at 9:26 am #15734Steve MooreMember
I've searched for “mysql host address” in order to try and define what should be typed in there and there was no results available to display.
A scroll through the downloaded help file is par for a windows based helpfile – none at all.
How do I find out what I need to put in this field ? I know the answer is the details of the mysql host address, that info in that form I don't need, but where do I look on my system to know what actually needs typing in ?
-
June 7, 2004 at 9:20 pm #15735ShadowMember
The correct MySql host name is either the IP address or the FULL NAME of the computer running MySql server. If MySql is provided by an ISP, then ask them for details. If you run it yourself, then check out your OS' manual how to find the full name or IP address of that machine.
-
-
AuthorPosts
- You must be logged in to reply to this topic.