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 vote161 views1 answer
Delete a record from a table sqlite3
SQL
0 vote133 views1 answer
Mysql case when on date
SQL
-2 votes154 views2 answers
Union all in sql
SQL
0 vote286 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
-1 vote148 views1 answer
Export mysql table to file
SQL
0 vote147 views1 answer
Like and not like together in sql
SQL
42 votes219 views6 answers
Install beautifulsoup
SQL
16 votes151 views3 answers
Update table from another table
SQL
0 vote162 views1 answer
Soql last week
SQL
1 vote192 views1 answer
Add time to date sql
SQL