MySQL connection over SSH tunnel - how to specify other MySQL server?

mysql ssh-tunnel
Mad Marvin picture Mad Marvin · Aug 22, 2013 · Viewed 58k times · Source

I've got ~50 databases all set up at different host names, with the requirement that I connect to them through an SSH tunnel.

For example:

  • SSH host at ssh.example.com

  • MySQL host at mysql1.example.com

I have managed to create the tunnel using autossh (web server running Debian), but I can't seem to figure out how to connect to a specific MySQL hostname "beyond" the SSH tunnel.

Typing lsof -i -n | egrep '\<ssh\>' confirms that the tunnel is working (sends port 3307 to ssh.example.com port 3306)

So when I try mysql -h 127.0.0.1 -P 3307 I get Connection refused. Not too weird since it's not an MySQL server.

My question to you guys:

How do I specify the mysql1.example.com host AFTER creating the SSH tunnel? I've tried searching everywhere but can't seem to figure it out.

Answer

Mad Marvin picture Mad Marvin · Aug 22, 2013

Solved it! The thing was to connect to the correct server when creating the tunnel itself - should've seen that one coming.

ssh -f [email protected] -L 3307:mysql1.example.com:3306 -N

Then mysql -h 127.0.0.1 -P 3307 worked as intended. :)

Related questions

How to connect MySQL database using Python+SQLAlchemy remotely?

I am having difficulty accessing MySQL remotely. I use SSH tunnel and want to connect the database MySQL using Python+SQLALchemy. When i use MySQL-client in my console and specify "ptotocol=TCP", then everything is fine! I use command: mysql …

Read More
MySQL connection over SSH tunnel

I have set up a SSH tunnel between two servers A and B. B has MySQL server, and this works: mysql -h localhost -P 3306 -u user -p While this doesn't: mysql -h 127.0.0.1 -P 3306 -u user -p Although my.cnf has …

Read More
why is mySQL connecting at any/all ports

I'm running Linux Mint and trying to connect to mySQL this way mysql --port=3306 -u root -p Then it prompts me for my password. This is all fine. Why is it that when I type something like this it still …

Read More