Can I SSH to MySQL with the GUI tools?

mysql linux ubuntu ssh firewall
Neil Middleton picture Neil Middleton · May 13, 2009 · Viewed 12.2k times · Source

I have a ubuntu server which I've locked down to only HTTP, HTTPS and SSH (port 30000). On this box I have a MySQL server which 99.9% of the time is only used locally. Every now and then I want to connect to the MySQL instance with the GUI tools, but without touching the firewall.

Therefore, it is possible to set things up so that I can connect to the MySQL box with the SSH connection? Is there any sort of port forwarding magic I can do?

Answer

Daniel Cassidy picture Daniel Cassidy · May 13, 2009 
ssh -L localport:127.0.0.1:remoteport user@remotehost

where localport is an unbound port on your local system, remoteport is the port on which MySQL listens, 127.0.0.1 is the loopback address on your remote system, user is your user name and remotehost is the address of the remote system.

Then point your MySQL client to 127.0.0.1:localport. The connection will be forwarded over the SSH tunnel to the remote port.

Related questions

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' -- Missing /var/run/mysqld/mysqld.sock

My problem started off with me not being able to log in as root any more on my mysql install. I was attempting to run mysql without passwords turned on... but whenever I ran the command # mysqld_safe --skip-grant-tables & …

Read More
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am an electrical engineer who mainly plays around with power systems instead of programming. Recently, I have been following a manual to install a software suite on Ubuntu. I have no knowledge of mySQL at all, actually. I have …

Read More
How to test which port MySQL is running on and whether it can be connected to?

I have installed MySQL and even logged in there as a user. But when I try to connect like this: http://localhost:3306 mysql://localhost:3306 Neither works. Not sure if both are supposed to work, but at least one of them …

Read More