forums › forums › SQLyog › Using SQLyog › Remote host connect problems
- This topic is empty.
-
AuthorPosts
-
-
March 17, 2005 at 2:35 am #88601900Member
Recently purchased sqlyof enterprise. I had no trouble connecting to a mySQL serve on my computer but cannot access mySQL server on my ISP. I've double and triple checked host address (in this case: database.ispname.com), mysql login and mysql password. I have also uploaded the tunnel file to a directory on my website, though I don't know if it can “see” the mysql server.
If tunneling is selected it says “cannot contact tunnel url”
If tunneling is unchecked is says “unknown mysql host database.ispname.com”
The tunnel php file is accessible on the web, so it's in place.
I have the same problem with all other mysql software — mySQL administrator has the same recognition problem. (That utility has a ping check feature on the named host and it pings fine.)(phpmyadmin is up on the ISP server and I can access that just fine on the web, for what information that datum contains)
I've tried every sensible variation on the info. I asked my ISP about it but quickly ran out of intelligent questions. This is one of those deals that's so straightforward on the surface there's no obvious next step.
-
March 17, 2005 at 8:31 am #17188RiteshMember
Can we chat on MSN or Yahoo?
-
March 17, 2005 at 1:56 pm #171891900Member
re: chat
Unfortunately not, or if we can I am unfamiliar with the capability.
-
March 17, 2005 at 4:20 pm #17190peterlaursenParticipant
I think you are almost there!
The message “unknown mysql host database.ispname.com” tells that that the tunnel php file actually is able to connect to the mysql system, but only the databasename is unknown.
So probably just should just supply your username as a prefix for the database like user_mydbname or something like that . Mine is looking like the pic below. It could also be that your ISP has more (physical) Mysql servers and you should supply a number lik 21″ in “mydb1”.
What is the connection string used by myphpadmin ? Should be the same!
All that information should be available from the “control panel” of your web account.
-
-
AuthorPosts
- You must be logged in to reply to this topic.