If you have a server infrastructure like following:
[Win dev machine] <=ssh=> [Gangway Server] <=ssh=> [App Server] <--> [MySQL DB]
We can access DB via SSH Tunnel, following these steps:
-
Using Git Bash or OpenSSH client for Windows 10, invoke command:
ssh user_id@Gangway_Server -L 2202:App_Server:22 -N
after typing the login password of user_id of Gangway Server, leave this terminal window opened.
Open MySQL Workbench, create connection using Stand TCP/IP over SSH, other settings like this screenshot:
After everything is done, close MySQL Workbench before closing the Terminal Window.
Top comments (0)