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 vote176 views1 answer
How to use select union and loop
SQL
0 vote95 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
8 votes110 views2 answers
Grant all privileges database postgres to user
SQL
0 vote108 views1 answer
Get id if is not equal in certain table
SQL
1 vote345 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
9 votes119 views3 answers
Where clause sql
SQL
0 vote97 views1 answer
Show database not empty tables postgres
SQL
0 vote118 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote110 views1 answer
Createdb with postgresql on ubuntu
SQL
1 vote101 views1 answer
Pgsql sum switch case
SQL