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 vote176 views1 answer
Stop and start mysql
SQL
0 vote144 views1 answer
Oracle get running queries
SQL
1 vote147 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote145 views1 answer
C# get sql min date
SQL
0 vote149 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote149 views1 answer
Plsql check how much space all databases are consuming
SQL
14 votes141 views3 answers
Sql trim from string
SQL
0 vote102 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
31 votes152 views3 answers
Sql count
SQL
16 votes133 views1 answer
Mysql mediumint max value
SQL