Re: SSH connection from a client machine - localhost works but not 127.0.0.1

2004-08-07 Thread Whil Hentzen
On Monday 02 August 2004 22:34, James Weisensee wrote: > What does your '/etc/hosts' file contain? Sounds like > it may have the following entry: > > 127.0.0.1 localhost.localdomain > > change it to: > > 127.0.01localhost Actually, it has 127.0.0.1 localhost.localdomain localhost

Re: SSH connection from a client machine - localhost works but not 127.0.0.1

2004-08-02 Thread Michael Stassen
From mysql's point of view, localhost and 127.0.0.1 are not the same thing. When you connect with mysql -h localhost -u root -p or simply mysql -u root -p (localhost is the default), you are connecting via unix socket, so the user=root, host=localhost entry is used. When you connect with

Re: SSH connection from a client machine - localhost works but not 127.0.0.1

2004-08-02 Thread James Weisensee
What does your '/etc/hosts' file contain? Sounds like it may have the following entry: 127.0.0.1 localhost.localdomain change it to: 127.0.01localhost or Yes, add 'localhost.localdomain' to mysql.user another option, Why not just SSH to 'daisy' and issue: shell> mysql -u root -p a

Re: SSH Connection

2002-11-11 Thread Michael T. Babcock
Insanely Great wrote: Greetings I am writing a C app wherein I have to connect to MySQL server whcih is on SSH connection. How can I connect to the server using mysql_real_connect () Just use SSH to create a local tunnel then connect to localhost ... -- Michael T. Babcock C.T.O., FibreSpee

Re: ssh connection between web server and mysql]

2001-04-13 Thread Jeremy Zawodny
On Fri, Apr 13, 2001 at 09:35:38AM +0800, Leon Harris wrote: > > I believe that the session was idle. It also does it when I give the > -2 option to ssh ( ssh2 is supposed to not time out, according to > some usenet posts I have read). The point of the excercise is to > have an encrypted connect

Re: ssh connection between web server and mysql

2001-04-12 Thread Leon Harris
Hi Jeremy, thanks for your reply. I believe that the session was idle. It also does it when I give the -2 option to ssh ( ssh2 is supposed to not time out, according to some usenet posts I have read). The point of the excercise is to have an encrypted connection that I can make DBI calls to the

Re: ssh connection between web server and mysql]

2001-04-12 Thread Leon Harris
[EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query > > If you just reply to this message, and include

Re: ssh connection between web server and mysql]

2001-04-12 Thread Jeremy Zawodny
On Thu, Apr 12, 2001 at 02:32:42PM +0800, Leon Harris wrote: > > On the client I do a > ssh -q -n -f -l account -L 3306:mysqlserver.mydomain.com:3306 > > then mysql -u dbuser --port=3306 -h 127.0.0.1 -p dbname > and I get an encrypted connection. ( thats what tcpdump shows me) ! > Lovely ! > >