Remote mySql acces.. :-(

**puckchaser** · January 2nd, 2008, 11:23 PM

Need some help here.... I have succesfully connected to mySql via Sqlyog previously (I even wrote a wiki on it)

But now I cannot connect. Here's what I have tried:

(1) Set remote access in cPanel to my IP, my IP range, and % (all)

(2) Tried access from my home network. on

MacBook Pro (no firewall) using cocoaSql
WinXP under VMware Fusion (on the mac) using sqlyog
WinXP (native not firewall) using sqlyog

Home network has no firewall on outbound messaging, and there were log entries on restricted inbound.

(3) Tried access from my 3G aircard on WinXP laptop.

Set the remote access IP to my aircard IP. That failed too

(4) For host name, I have used my domain, server IP, and surpass hostname (sh110.surpasshosting.com). all fail.

(5) Created new database, and user. Verified that I am using the proper password.

(6) By default, all attempts were on port 3306.

(7) Yes, I test things for a living, so I think I tested every configuration available to me right now.

Am I missing something? Is SH110 whacked out?

Thanks.

edit - Maybe the server load

8.47 is not soo good....

**puckchaser** · January 4th, 2008, 1:52 AM

Well, no one took up my challenge.. So I opened a ticket... if anyone is interested, here is the ticket number ... VVY-567778

Also, server load dropped and is still a no-go.

**puckchaser** · January 4th, 2008, 12:32 PM

They fixed it, there was a firewall blocking port 3306.

**FredFredrickson** · January 10th, 2008, 12:27 PM

Yes, by default they block 3306 from outside use. I've never been able to remotely administer mysql.

**removed** · January 10th, 2008, 2:27 PM

All it takes is a ticket, Fred.

**MarkRH** · January 11th, 2008, 12:56 AM

Guess that port had been unblocked on my server before I got on to it. I've been remoting into it since day 1.

tibberous · January 11th, 2008, 4:58 AM

Remote mySQL access is awesome. If you use navicat you can setup an SSH tunnel on port 22 and keep 3306 blocked, which I believe is more secure. If nothing else it means that someone has to have your shell password and your database password, and that if someone can somehow plaintext your database config file, your still protected.

**FredFredrickson** · January 11th, 2008, 11:01 AM

When I submitted a ticket and was told they did it by default. I lost the need for remote admin, so I never ended up requesting they open it.

**puckchaser** · January 11th, 2008, 11:10 AM

Quote:

Originally Posted by tibberous

Remote mySQL access is awesome. If you use navicat you can setup an SSH tunnel on port 22 and keep 3306 blocked, which I believe is more secure. If nothing else it means that someone has to have your shell password and your database password, and that if someone can somehow plaintext your database config file, your still protected.

*ding*

Considering I SSH tunnel to my home everyday.. I can't believe I didnt think about trying this.

Also, you should be able to setup SSH tunnel with any sql client. Just use Putty to create your tunnel, and then set the host in your sql client to 'localhost' and you should hit the remote sql.

January 2nd, 2008, 11:23 PM	#1 (permalink)
puckchaser He shoots.. He scores! Super #1 Joined in Feb 2007 Lives in A room with no windows. Hosted on SH110 1,448 posts Gave thanks: 46 Thanked 140 times	Remote mySql acces.. :-( Need some help here.... I have succesfully connected to mySql via Sqlyog previously (I even wrote a wiki on it) But now I cannot connect. Here's what I have tried: (1) Set remote access in cPanel to my IP, my IP range, and % (all) (2) Tried access from my home network. on MacBook Pro (no firewall) using cocoaSql WinXP under VMware Fusion (on the mac) using sqlyog WinXP (native not firewall) using sqlyog Home network has no firewall on outbound messaging, and there were log entries on restricted inbound. (3) Tried access from my 3G aircard on WinXP laptop. Set the remote access IP to my aircard IP. That failed too (4) For host name, I have used my domain, server IP, and surpass hostname (sh110.surpasshosting.com). all fail. (5) Created new database, and user. Verified that I am using the proper password. (6) By default, all attempts were on port 3306. (7) Yes, I test things for a living, so I think I tested every configuration available to me right now. Am I missing something? Is SH110 whacked out? Thanks. edit - Maybe the server load 8.47 is not soo good.... __________________ SH110 Last edited by puckchaser; January 2nd, 2008 at 11:34 PM..

January 4th, 2008, 1:52 AM	#2 (permalink)
puckchaser He shoots.. He scores! Super #1 Joined in Feb 2007 Lives in A room with no windows. Hosted on SH110 1,448 posts Gave thanks: 46 Thanked 140 times	Well, no one took up my challenge.. So I opened a ticket... if anyone is interested, here is the ticket number ... VVY-567778 Also, server load dropped and is still a no-go. __________________ SH110

January 4th, 2008, 12:32 PM	#3 (permalink)
puckchaser He shoots.. He scores! Super #1 Joined in Feb 2007 Lives in A room with no windows. Hosted on SH110 1,448 posts Gave thanks: 46 Thanked 140 times	They fixed it, there was a firewall blocking port 3306. __________________ SH110

January 10th, 2008, 12:27 PM	#4 (permalink)
FredFredrickson Senior Member Super #1 Joined in Nov 2003 Lives in New Hampshire 1,260 posts Gave thanks: 3 Thanked 27 times	Yes, by default they block 3306 from outside use. I've never been able to remotely administer mysql. __________________

January 10th, 2008, 2:27 PM	#5 (permalink)
removed Surpass Abuse Admin Super #1 Joined in Mar 2005 Lives in Houston, TX Hosted on NONE 7,797 posts Gave thanks: 11 Thanked 278 times	All it takes is a ticket, Fred. __________________ Unofficial IRC Channel: #surpass EFNet Unofficial = No official support. Support requests can be submitted to our helpdesk.

January 11th, 2008, 12:56 AM	#6 (permalink)
MarkRH Race Surpass Super #1 Joined in Jul 2006 Lives in Oklahoma City, OK Hosted on sh102 1,222 posts Gave thanks: 18 Thanked 86 times	Guess that port had been unblocked on my server before I got on to it. I've been remoting into it since day 1. __________________ SH102 : Mark Headrick - Blog - Gallery Pelicar \| Company of Valor \| Mysstie Wolfestar

January 11th, 2008, 4:58 AM	#7 (permalink)
tibberous Registered User Seasoned Poster Joined in Oct 2007 55 posts Gave thanks: 3 Thanked 3 times	Remote mySQL access is awesome. If you use navicat you can setup an SSH tunnel on port 22 and keep 3306 blocked, which I believe is more secure. If nothing else it means that someone has to have your shell password and your database password, and that if someone can somehow plaintext your database config file, your still protected.

January 11th, 2008, 11:01 AM	#8 (permalink)
FredFredrickson Senior Member Super #1 Joined in Nov 2003 Lives in New Hampshire 1,260 posts Gave thanks: 3 Thanked 27 times	When I submitted a ticket and was told they did it by default. I lost the need for remote admin, so I never ended up requesting they open it. __________________

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread: