How to use ssh tunnel to connect to mysql server

Preface

In some cases, we only know the intranet address of the database and cannot connect through the intranet, but we can log in to other machines in the same intranet, and these machines can access the database in the intranet, then we can access the database through the ssh tunnel method.

usage

The usage of ssh tunnel is very simple, the specific format is as follows:

ssh -L [local port]:[remote host]:[remote port] [username]@[remote host]

Use the -L method to forward access to the local port to the port on the remote host through the ssh tunnel. In actual use, we can also add -f and -N parameters to make the ssh command work in the background without executing any commands.

practice

Assume that the intranet IP of our MySQL server is 10.86.22.22 and is enabled on port 3306. The external IP of another server in the same intranet as MySQL is 121.43.23.12.

First execute locally:

$ ssh -f -N -L 12345:121.43.23.12:3306 [email protected]

Then execute locally:

$ mysql -u root -P 12345 -h 127.0.0.1 -p

After entering the password, you can log in to MySQL.

After the execution is complete, we can use ps to find the sshd connection that was just established, and then kill it to close the ssh tunnel that was just established.

Summarize

The above is the full content of this article. I hope that the content of this article can be of some help to your study or work. If you have any questions, you can leave a message to communicate.