Question about remote access through SSH tunnel...

[Todd Calhoun]

Hi,

I've got a MySQL database being hosted by a company. The site has
phpMyAdmin for external administration, but I'd like to use a program
like EMS MySQL manager, or maybe even an OBDC connection for certain
things. But I can't get the SSH tunnel to work.

I can access the account using an SSH logon through putty, and once in,
I can access MySQL using the terminal. But I can't get port forwarding
to work.

If MySQL is working with phpMyAdmin, shouldn't it be able to work with
an SSH tunnel?

The phpMyAdmin settings are as follows, the version is MySQL 3.23.56:

------------------------------------------------------
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['port'] = ''; // MySQL port -
leave blank for default port
$cfg['Servers'][$i]['socket'] = '/var/lib/mysql/mysql.sock';
// Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'socket'; // How to connect
to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed
protocol for the MySQL connection
// (requires PHP >=
4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control
user settings
// (this user must
have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the
"mysql/user"
// and "mysql/db"
tables)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication
method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = "*******"; // MySQL password
(only needed
// with 'config'
auth_type)
----------------------------------------------------