Very often in our work, we have a remote database with closed remote connections, but somehow we need to get data from it. So we have connection string with login, password, we also have ssh account on the remote server, but the database is closed for remote connections. The solution is SSH tunnel.
It is possible to setup PhpStorm to get access to the database via ssh tunnel. When adding a new database source we have SSH/SSL tab. Here we fill our ssh credentials:
Then on the General tab we fill credentials for the remote database. Don’t forget to use localhost in the host field:
Done! Now we have a connection to our remote database via ssh tunnel.
Connection in code
But what if we need to query to our remote database in our application? How to deal with it? First of all, we need to create an ssh tunnel to remote host:
-v can be removed, I use it for verbose. Then after
-L option you a free port on your machine, then the port on the remote host, and at the end your ssh credentials.
After that, in our application, we should use
localhost as the host, and port
3336 to connect to the remote database.