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 vote201 views1 answer
Commit transaction sql
SQL
1 vote216 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote161 views2 answers
Jupyter notebook connect to database
SQL
0 vote224 views1 answer
Mysql sleep connections
SQL
0 vote212 views1 answer
Where in clause tsql
SQL
0 vote218 views2 answers
Sql query for getting details by id
SQL
9 votes222 views6 answers
Check constraint in sql
SQL
2 votes195 views1 answer
Import database in mysql command line xampp
SQL
2 votes227 views3 answers
Sql function
SQL
0 vote240 views1 answer
MySql get primary keys of table
SQL