Instructions for connecting phpmyadmin to a remote server w/ ssh tunnel

ssh_tunnel_for_phpmyadmin.sh

# https://degreesofzero.com/article/manage-remote-mysql-servers-with-local-phpmyadmin.html

# open tunnel
ssh -fNL 3307:localhost:3306 USERNAME@HOST

# test tunnel
ps aux | grep ssh

# on local, open myadmin config
sudo nano /etc/phpmyadmin/config.inc.php

# Add the following after all the existing server configurations:
$cfg['Servers'][$i]['verbose']       = 'Remote Server';// Change this to whatever you like.
$cfg['Servers'][$i]['host']          = '127.0.0.1';
$cfg['Servers'][$i]['port']          = '3307';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['extension']     = 'mysqli';
$cfg['Servers'][$i]['compress']      = FALSE;
$cfg['Servers'][$i]['auth_type']     = 'cookie';
$i++;

## 
ps aux | grep 3306
kill <pid>