Forum: 

Trying to Access MySQL with NaviCat Remotely... what port for SSH?

Landis Arnold's picture

I am testing to see if i can access MySQL Data remotely with Navicat.  They say you can get to it via SSH or HTTP...  that said, I can't seem to get it to work.

I know on the Web-SSH it is port 12320.  Evidently default SSH is 22.  Which port should I specify in Navicat to get a DataTunnel going?

Right now I am trying to get to Magento Data but it could be any, including PostGRE on other appliances.

thanks for any help,

Jeremy Davis's picture

But TKL uses the default SSH port 22. AFAIK whilst Shell-in-a-box (Web shell available port 12320) is technically SSH, it is just a web interface.

Ron's picture

You set your mysql server configuration to listen to ANY IP (or your specific IP), by default it is set to localhost only....

lulo lulito's picture

From my little knowledge ssh and mysql are two diferent cats, ssh uses port 22 while mysql uses 3306, what you need to do is forward a port on your firewall, WARNING it is not recomened to have remote access to mysql databases, securty comes first.

use a vpn and connect to your local mysql server.

Landis Arnold's picture

I can access via SSH so the security is the same as SSH (good or bad).  There are places for sure where other external access could be helpful (syncronizing FoxPro and MySQL via  Windows Machine) but I have not implemented that because of the same security concerns mentioned.

If MySQL access could be defined to, for instance, a single IP or Subnet inside the Firewall I couild see this working however.  I will poke around a bit.

schwipps's picture

Did you manage to access your ddb via ssh with Navicat ?

Landis Arnold's picture

Yes.  Not sure why it stopped working but it started up again.

schwipps's picture

Really ?! Can I ask you to take 5 minutes to describe the configuration steps ? I've been looking for months now. That would be very helpful !

Landis Arnold's picture

I am not sure what you are wanting to log into.  There have been several seeming phishes here recently.

What version of Navicat do you have and what appliance?

Jeremy Davis's picture

Then have a look here at the TKL docs. By default TKL appliances have the DB bound to local host.

Alvin's picture

I've yet to have any luck getting the SSH tunnel to work with AWS to EC2

it seems that the identity.pem file is unusable as a Public Key for Navicat 

any ideas?

Jeremy Davis's picture

If you can successfully connect via SSH but not with Navicat then perhaps try setting a password and connect with that?

Post new comment