Accessing MySQL server remotely using SSH Tunnel

Step 1 Allow DB access to the hosts 172.16.%.% - refer - https://docs.n99panel.com/doku.php?id=nodejs:mysql

Step 2 On the Linux machine from where you are trying to access the DB remotely, you need to run the SSH command with the following format

ssh -p USER_SSH_PORT -L 3306:172.16.26.1:3306 SSH_USER@SERVER_HOST -N

An example command is

ssh -p 13002 -L 3306:172.16.26.1:3306 userabc@cl0099-cl0001.wp-cl.clients.n99p-r1.com -N

Now if the above command runs fine i.e. displays no output or error, from an another window of your remote system, trying running mysql command like

mysql -u MYSQL_USER -p MYSQL_DB -h 127.0.0.1 -P 3306