How to access server with HeidiSql via SSH?

Hi

Ok fairly new here and almost there with setting up everything. But I am having some trouble connecting remotely to the server with HeidiSql via SSH and wondered if someone could provide some guidance.

Firstly I can connect with Putty on windows fine and have connected using the mysql console so all un and pw's are correct. I need to know what I am entering first for the Settings screen in HeidiSql so:

Hostname/IP, User, Password.

Network Type I have set as MySQL (SSH Tunnel) and port as 3306

Then what I need to input under the SSH Tunnel tab:

SSH host + port, username and password, private key file (assuming same one as using for putty) and Local Port.

I've tried various combindations of the linode IP with root user, my own user, localhost, 127.0.0.1 and nothing appears to work. I'm also already logged in via putty.

Any help much appreciated.

Cheers

1 Reply

Are you using a PC or Mac/Linux? On PC there's a tool called PuTty that needs to have a configuration set, but for Mac/Linux you'll need to run a specific command in your terminal. Each method is explained here:

https://www.linode.com/docs/databases/m … ssh-tunnel">https://www.linode.com/docs/databases/mysql/securely-administer-mysql-with-an-ssh-tunnel

Good luck!

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct