Shulou(Shulou.com)06/01 Report--

This article mainly introduces in detail the method of accessing Mysql through SSH channel forwarding. The sample code in this article is very detailed and has a certain reference value. Interested friends can refer to it.

Access Mysql through SSH channel forwarding

Scene:

Mysql server: test.cn Mysql_Listen: 127.0.0.1 SSH_Port 3306: 8888Client: local.cn

SSH channel forwarding

Ssh-fNg-p 8888-L 3306 User@test.cn 127.0.0.1 User@test.cn

Check whether the local port 3306 is listening.

Ss-lntp | grep '3306'

Mysql Client connection

Mycli-h localhost-P 3306-u user-p password

These are the details of the method of accessing Mysql through SSH channel forwarding. Have you learned anything after reading it? If you want to know more, welcome to the industry information!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.