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

13 votes347 views4 answers
Command line mysql import
SQL
1 vote332 views1 answer
Create new table in SQL from old table with data
SQL
1 vote369 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote346 views1 answer
Connexion mysql
SQL
2 votes299 views1 answer
Sql select in list
SQL
0 vote370 views1 answer
Pgadmin check database
SQL
32 votes358 views6 answers
Sql count where
SQL
3 votes332 views1 answer
Postgres update column with value from another table
SQL
25 votes375 views6 answers
Import database mysql command line
SQL
2 votes339 views1 answer
Mysql virtual column
SQL