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

0 vote251 views1 answer
Big query add table rows to another table
SQL
0 vote298 views1 answer
Get who is hired in february in sql
SQL
6 votes272 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote285 views1 answer
Mysql workbench indent formatting
SQL
15 votes283 views6 answers
Drop foreign key mysql
SQL
1 vote325 views1 answer
Concat first name and last name in mysql
SQL
0 vote299 views1 answer
PSQL use LIKE with timestamps
SQL
2 votes305 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
2 votes281 views1 answer
Sql alchemy or
SQL
2 votes297 views1 answer
Mysql trigger after update
SQL