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 vote323 views1 answer
Get null value in sql
SQL
7 votes328 views4 answers
Lowest salary in sql
SQL
0 vote300 views1 answer
Postgresql inline table
SQL
0 vote312 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote338 views1 answer
Sqlite get date only
SQL
0 vote323 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
15 votes308 views2 answers
Sql order by multiple columns
SQL
1 vote341 views1 answer
Pl sql create table from another table
SQL
1 vote315 views1 answer
Show structure of table in sql
SQL
0 vote333 views1 answer
Sql date time query find
SQL