What does it really matter is whether you have create mySQL user that allow access the database from the SSH server.
Please note that localhost, 127.0.0.1 or the machine ip address will be treated as different entries by mySQL. -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com > On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote: > > 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. > > What if you use 127.0.0.1 instead of "localhost"? > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.8: up 32 days, processed 1,006,604,456 queries (357/sec. > avg) > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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