Using ssh tunnel and mysql

[LZ Orders]

Hi. I wanted to connect from a client machine to a MySQL server using 
ssh. I execute the following on the local machine (the server is 
foo.bar.com):

% ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com

I then try to connect from the local machine with:

% mysql -h localhost -p 3307 --user=me --password

But after prompting me for my password, MySQL denies me access. I've 
successfully used this technique with Perforce to have encrypted 
Perforce communication, and I can ssh into the remote machine and use 
mysql without problems.

Anyone have any ideas why this isn't working for me? Thanks!

--
Rick
---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php