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

2 votes245 views1 answer
Power query concatenate
SQL
0 vote183 views1 answer
Oracle sql developer script output limit
SQL
0 vote237 views1 answer
Check if string is a number sql
SQL
0 vote233 views1 answer
Xamarin sql lite create table if not exist
SQL
11 votes232 views1 answer
Oracle view ddl
SQL
0 vote223 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote234 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
6 votes238 views2 answers
Oracle
SQL
0 vote230 views1 answer
Query string starts with vowels
SQL
0 vote233 views1 answer
Mysql update table from select on another table
SQL