In this example, the remote port 3306 on the remote server will be forwarded to local port 3307 using login@server for ssh credentials. The connection is pushed in the background and the port will remain forwarded as long as this ssh connection remains active.

ssh login@server -L 3307:127.0.0.1:3306 -N &