basic question

This topic is empty.

Viewing 7 reply threads

Author

Posts
- March 4, 2004 at 5:14 pm #8356
  
  Shade
  Member
  
  Hi
  
  i can't connect to my ISP's MySQL host. I get the 2003 error message. All settings are correct: port 3306, ip-adress of my IPS server. Username & Databasename.
  
  I'm behind a firewall: WinProxy. Could that be the Problem? If so. does anyone know a way to get past this?
  
  greetz, Shade :huh:
- March 4, 2004 at 5:31 pm #15538
  
  CalEvans
  Member
  
  What is the exact error message you get?
  
  When you get the error, does it tell you what server it is trying to connect to? If so, is that the correct server? (localhost is usually not the correct server)
  
  Have you checked to make sure that either 3306 is open on your winproxy or that it allows all outgoing connections? Yes, this could be the problem. You get around it by opening 3306, if this is the issue.
  
  More information is needed before more help can be given.
  
  =C=
- March 4, 2004 at 10:29 pm #15539
  
  Shade
  Member
  
  Hi CalEvans,
  
  I mapped the ports on the WinProxy Sever and the error message has changed. The error message i get now is:
  
  +
  
  Error no. 2013
  
  Lost connection to MySQl server during query
  
  +
  
  I actually have a MySQL Server running on that machine, which means that i cannot use port 3306, right?
  
  So i mapped another free port to the the 3306 port of my ISP using TCP. In SQLyog i use my ProxyServer as servername.
  
  I don't know, and can't any information on, how to open a port completely on WinProxy.
  
  According to my ISP i have to use the url of the website to approach MySQL. When i use the ip address i get the 2003 error message.
  
  +
  
  Error no. 2003
  
  Can't open MySQL server on “ProxyServer” (10061)
  
  +
  
  I guess i made some progress, at least it gets some connection now.
  
  Greetzzz, Shade
  
  and thx in advance for your help. 😕
- March 10, 2004 at 3:01 pm #15540
  
  Shadow
  Member
  
  As far as I'm concerned, SQLyog cannot be used behind firewalls. At least Ritesh keeps telling that…
- March 10, 2004 at 3:37 pm #15541
  
  CalEvans
  Member
  
  IF your ISP is (smart enough to be) running Linux then you can probably get them to let you setup an ssh tunnel.
  
  http://www.vandyke.com has a program (ssh tunnel?) that does just this. You don't need a shell account, just a login and password.
  
  I use SecureCRT (you can use PuTTY for free) do tunnel all the time.
  
  Once I have the connection made and the tunnel working, I fire up SQLyog and create a connection. The host is localhost, the port is whatever port I've assigned it to. (I have more than one and they can be open at the same time so I use unique ports on each tunnel) and voila! I have a secure connection to my server, through my firewalls.
  
  It's a bit more complex than that and I'm happy to help you if this will work. Let me know.
  
  =C=
- March 11, 2004 at 12:26 am #15542
  
  Shade
  Member
  
  Hi Shadow and Cal,
  
  thanks for your reply. I'll try to reach my ISP in the morning and see if i can get them to let setup an “ssh tunnel”. Hopefully they'll do.
  
  I have tried using “MySQL CC” and some other products, but none of them seemed to do the job.
  
  If i need help, i'll post again. Thanks in advance guys
  
  Greetz, Shade
- March 12, 2004 at 5:29 am #15543
  
  Anonymous
  Guest
  
  hello i'm a total newbie at this. .what address do i put in the
  
  MySql Host Address? domain.com@username?
  
  i created a Host Access in MySql but don't know how to call it.
- March 13, 2004 at 10:43 am #15544
  
  Shadow
  Member
  
  [email protected] perhaps… What is a “Host Access” anyway? And what do you mean by “calling it”?
Author

Posts