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 vote219 views1 answer
How much space does sql server take per row
SQL
10 votes201 views2 answers
Oracle alter sequence nextval
SQL
1 vote198 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
3 votes154 views1 answer
System.debug apex
SQL
0 vote193 views1 answer
Change role postgres
SQL
0 vote211 views1 answer
How to create a table in sql stack overflow
SQL
0 vote216 views1 answer
For row in sql database python loop
SQL
4 votes209 views1 answer
W3schools create table
SQL
1 vote211 views3 answers
Mysql on delete set null
SQL
0 vote176 views1 answer
Where case insensitive like mysql
SQL