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 vote352 views1 answer
Dnsmasq.conf location macos
SQL
10 votes339 views3 answers
Sql limit results
SQL
5 votes352 views1 answer
Mysql get last day of month
SQL
0 vote331 views1 answer
How many columns can be used for creating index?
SQL
3 votes360 views1 answer
Fk in insert mysql
SQL
0 vote359 views1 answer
This week mysql
SQL
1 vote384 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote350 views2 answers
Insert into
SQL
3 votes316 views1 answer
How to get list of synonyms in oracle
SQL
19 votes387 views6 answers
Mysql if null
SQL