Jeremy Zawodny wrote: > On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote: >> [...] >>so fra , so good. Then doing >> >># ssh [EMAIL PROTECTED] -L 80000:localhost:3306 >> >> >>and connecting to port 80000 on my machine with telnet gives me >>something like >> >>Trying ::1... >>Connected to localhost. >>Escape character is '^]'. >>, >>3.23.47-log$jhbjhb%kj >> >>which i suppose is a prompt from the remote mysql service >> > > Yes, that means it's working.
> > >>but then trying to connect to that port with the mysql client i get: >> >># mysql -u username -p -h my.local.hostname -P 80000 >>Enter password: >>ERROR 2003: Can't connect to MySQL server on 'my.local.hostname' (111) >> > > Try using "localhost" instead of "my".local.hostname". Since you > didn't use the `-g' option for SSH, I wouldn't expect what you're > doing to work. See the SSH docs for why. hmm, that won't work at all, as there is a "real" mysql server runnning on the same machine, using localhost or no hostname will result in the local unix socket configured with the mysql client will be used, ignoring the port number given on the command line, and only connecting me to the locally running daemon, as far as my exoerience goes. hmm, seems that is to be "ethereal'ed" when i have some more time to spend on this... henning --------------------------------------------------------------------- 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