TurnKey Linux Virtual Appliance Library

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

L. 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's picture

I'm not familar with NaviCat

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.

Solution...

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

MySQL doesn't work through SSH

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.

L. Arnold's picture

Navicat actually can access through SSH

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.

Did you manage to access your

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

L. Arnold's picture

Yes.

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

Really ?! Can I ask you to

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 !

L. Arnold's picture

I think it would be good to register first.

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's picture

If you're just after remote MySQL access

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

Did you get this working?

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's picture

Use a password instead?

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

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)