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

6 votes330 views1 answer
Oracle desc table primary key
SQL
0 vote297 views1 answer
Import sql mysql ubuntu
SQL
5 votes394 views3 answers
Create function in postgresql
SQL
1 vote337 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote353 views1 answer
Nvl2 syntax
SQL
0 vote369 views1 answer
Sqlalchemy _in array sqlite
SQL
1 vote345 views1 answer
Oracle create_program
SQL
3 votes320 views1 answer
Oracle rollback
SQL
1 vote312 views1 answer
Sql get missing id
SQL
1 vote343 views1 answer
How to convert number to hours and minutes in oracle sql
SQL