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

1 vote210 views1 answer
Sql row having max
SQL
4 votes192 views1 answer
W3schools create table
SQL
5 votes175 views2 answers
Copy data from one database to another
SQL
9 votes181 views2 answers
Get first 3 letters in sql
SQL
0 vote222 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote226 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote190 views1 answer
Sql on-premises
SQL
0 vote182 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote181 views1 answer
Incorrect string value: mysql
SQL
0 vote203 views1 answer
Define a variable in mysql from select
SQL