PHP - SSH tunnel to MySQL

Question

How to make self destructing SSH tunnel to access MySQL on another server?

Currently my code looks like:

exec('ssh -fNg -L 4343:127.0.0.1:3306 [email protected]');

$mysqli = new mysqli('127.0.0.1', 'dbuser', 'dbpass', 'dbname', '4343');

Problem here is that script hangs after making exec command. How should i execute rest of the script, and how to close background process once the script has finished?

Answer 1

So after some research - solution is to add > /dev/null 2>/dev/null & on the end of command.

Complete working example line is:

exec('ssh -fNg -L 4343:127.0.0.1:3306 [email protected] > /dev/null 2>/dev/null &');