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

13 votes173 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote166 views1 answer
Sqlite löschen einer tabelle
SQL
3 votes146 views1 answer
Oracle list user grants
SQL
0 vote146 views1 answer
Sequelize postgresql schema
SQL
0 vote224 views1 answer
How to add auto increment primary key
SQL
0 vote157 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote167 views1 answer
How to check default value of column in sql server
SQL
0 vote140 views1 answer
How to get employee having maximum experience in mysql
SQL
3 votes186 views3 answers
Order by postgres
SQL
0 vote150 views1 answer
Mariadb current date plus 1 day
SQL