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

19 votes103 views4 answers
Rename database in sql
SQL
0 vote115 views1 answer
Mysql grant user wildcard database
SQL
2 votes114 views1 answer
Sql string starts with
SQL
6 votes99 views1 answer
Oracle trigger after logon on database
SQL
1 vote112 views1 answer
Mysql count multiple columns in one query
SQL
-2 votes118 views2 answers
Union vs union all in sql
SQL
1 vote126 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote104 views1 answer
How to output a different column name in mysql
SQL
0 vote100 views1 answer
Composit key in sql
SQL
24 votes106 views4 answers
Delete db postgres
SQL