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

4 votes176 views2 answers
Convert utc to est sql
SQL
0 vote152 views1 answer
Postgresql conectar
SQL
50 votes251 views6 answers
Sql count duplicate rows
SQL
2 votes169 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote181 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
1 vote172 views1 answer
How to delete a record from sqlite in android
SQL
0 vote151 views1 answer
Get only first row mysql
SQL
9 votes171 views3 answers
Import DB through mysql console
SQL
19 votes174 views2 answers
Mysql tinyint max value
SQL
1 vote180 views2 answers
Oracle 18c xe ORA-65096
SQL