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

3 votes289 views1 answer
Oracle show trigger code
SQL
0 vote189 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote195 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote184 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote240 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote193 views1 answer
Update one column from another column in same table
SQL
0 vote204 views1 answer
Oracle list partitions
SQL
0 vote195 views1 answer
Sqlite commands
SQL
2 votes197 views1 answer
Compare date in sql
SQL
0 vote190 views1 answer
Postgres list tables and row counts
SQL