I set up phpMyAdmin on the local side. I am having trouble connecting it to my remote server. I use 1&1 hosting and I found a tutorial about doing exactly what I want, except for the fact that I can only connect using SFTP and the tutorial is using SSH. I thought these were the same.
http://franklinstrube.com/blog/remote-mysql-administration-for-1and1/
This tutorial is telling me I need to install socat and do an SSH tunneling, but it is not accepting any commands from this tutorial since I can only us SFTP.
Here is my local host config for the phpMyAdmin
$cfg['Servers'][$i]['host'] = '';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'username';
$cfg['Servers'][$i]['password'] = 'password';
My current problem is the difference in the tutorial between their use of SSH and my ability to only us SFTP. How can I overcome this?