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 vote256 views1 answer
Doctors appointment
SQL
0 vote185 views1 answer
Postgres set default schema
SQL
0 vote241 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote189 views1 answer
Tsql cmd exec script from file
SQL
0 vote191 views1 answer
Oracle sql copy table without data
SQL
0 vote223 views1 answer
Basic structure of sql expression having clause
SQL
-1 vote174 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote183 views1 answer
Sql server remove enter from string
SQL
0 vote181 views1 answer
Monthly Birthday SQL Query
SQL
0 vote176 views1 answer
How to connect postgresql database with java
SQL