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 votes268 views1 answer
Oracle kill job by sid
SQL
2 votes259 views2 answers
Select list is not in group by clause
SQL
10 votes278 views2 answers
SQL rounding numbers
SQL
4 votes305 views1 answer
Ms sql truncate table vs delete
SQL
2 votes279 views1 answer
Search query in mysql
SQL
0 vote254 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote215 views1 answer
How to connect sql server using ip address in c#
SQL
1 vote249 views1 answer
Oracle start job
SQL
0 vote274 views1 answer
Sql count null values in all columns
SQL
2 votes247 views1 answer
Install sqlite npm
SQL