Ssh mysql port forwarding

ssh -N -f -L 3336:127.0.0.1:3306 [USER]@[SERVER_IP]

The options used are as follows:

-N - Tells SSH not to execute a remote command.
-L 3336:127.0.0.1:3306 - Creates a local port forwarding. The local port (3306), the destination IP (127.0.0.1) and the remote port (3306) are separated with a colon (:).
[USER]@[SERVER_IP] - The remote SSH user and server IP address.

To run the command in the background, use the -f option.
If the SSH server is listening on a port other than 22 (the default) specify the port with the -p [PORT_NUMBER] option.

Source: linuxize.com

Similar codes

0 vote146 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote142 views1 answer
Acual month sql
SQL
1 vote150 views1 answer
Mamp mysql path mac
SQL
1 vote154 views1 answer
Sql server epoch to datetime
SQL
0 vote187 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
3 votes160 views1 answer
Oracle revoke
SQL
1 vote207 views1 answer
Find size of all DB's postgres
SQL
1 vote136 views1 answer
Sql alchemy with azuresql server
SQL
0 vote180 views1 answer
000webhost database values insert
SQL
0 vote152 views1 answer
Sql put two columns into one
SQL