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 vote268 views1 answer
Export partttion and import in oracle
SQL
0 vote274 views3 answers
Sql count condition
SQL
0 vote269 views1 answer
Sql remove last 2 digit
SQL
0 vote278 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote290 views1 answer
Trigger stock phpmyadmin
SQL
0 vote280 views1 answer
Exectuer myssql .sql
SQL
2 votes285 views1 answer
Oracle list duplicates
SQL
5 votes269 views1 answer
Oracle find foreign key dependencies
SQL
0 vote303 views1 answer
Select distinct after join
SQL
0 vote281 views1 answer
Sqlite explain plan
SQL