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

26 votes340 views6 answers
Modify column name in sql
SQL
0 vote339 views1 answer
T-SQL Retry (deadlock)
SQL
1 vote352 views2 answers
Mysql: command not found
SQL
2 votes330 views1 answer
Oracle sql query to make column data uppercase
SQL
6 votes384 views4 answers
Mysql update set
SQL
1 vote375 views1 answer
Update substring in mysql
SQL
0 vote364 views1 answer
Rabbitmq ui not working
SQL
0 vote336 views1 answer
Implicit inner join table alias with id values
SQL
1 vote335 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote366 views1 answer
Hoq to import database source
SQL