error of 2003

[pencap]

trying to connect to a remote DB..

http://forums.westhost.com/phpBB2/viewtopic.php?p=296

I posted all about it there…

how would I be able to pipe everything through SSH?

would port forwarding work?

[Shadow]

You may not have the right permissions to connect to the MySql server or if you do then the portnumber may not be the default. Usually ISP's allowing MySql on their servers provide a way to connect, otherwise it would not make too much sense. Ask them!

[pencap]

that is what my host said…

Quote:

Due to security issues you cannot connect to the database except from the server itself.  You will have to write something up in perl or php script to do so.  This script will run server side and you will call it in your webpage.

so I can connect to the DB through a script ?? grrr..

[Shadow]

Probably you can set up phpMyAdmin on the remote server. It is entirely script based (php) and has all the RDBMS features you may require.

[pencap]

yeah but there are some features in sqlyog which are very nice..

[Ritesh]

:huh:

Too bad. You need to have proper permission to connect through SQLyog

[Shadow]

Sure it has, but it requires direct connection to the MySql db…

[CalEvans]

If you have ssh access to the server then you can tunnel mysql (port 3306) over a ssh connection. It looks to the server like you are connecting locally.

1: setup the port forwarding in your favorite ssh client. I use http://www.vandyke.com's SecureShell

2: connect your ssh client to your server.

3: If your tunneling is working correctly then fire up SQLyog and tell it to connect to the server localhost. put in your username and password for your server, click the connect button.

It works for me every time. I have 1 server that I keep closed off to the public but using this technique I am able to use this wonderful tool with it.

HTH,

=C=

[pencap]

grrr.. I can't get this to work..

I am using SecureCRT using SSH2 and Blowfish (this is what the host's site says to use)…

Port forwarding

– local address: 127.0.0.1:3306

– remote host: 127.0.0.1:3306

Remote

– local address: 127.0.0.1:3306

– remote host: 127.0.0.1:3306

in SQLyog…

– address: localhost

– username: blah

– password: blah

– db: blahdb

– port: 3306

…

please help 🙁

[CalEvans]

1st question

Can you connect to the server using ssh? (Do you get the shell prompt?) If you can't get that far then nothing else will work.

It sounds to me like the difference is you don't need to put anything in the IP address slot of either the remote or the local.

Also, remove the one you setup in remote. I'm not sure what that area is for but I NEVER use it. (and I have about 20 port forards setup for different things.)

HTH,

=C=

[CalEvans]

Screenshot from SecureShell

[Author]

Posts