Thanks for your advices.

In the offical mysql webpage, there is a paragraph tell us how to usinng
telnet test mysql server connectivity.
---------------------------------------------------------------

http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html

If you get the error message Can't connect to MySQL server on
some_hostname, you can try the following things to find out what the
problem is : 

Check if the serveis up by doing telnet your-host-name tcp-ip-port-number
and press Enter a couple of times. If there is a MySQL server running on
this port you should get a responses that includes the version number of
the running MySQL server. If you get an error like telnet: Unable to
connect to remote host: Connection refused, then there is no server
running on the given port. 

---------------------------------------------------------------------
Why i do this test is because I have trouble to use jdbc to connect to
mysql server and i am afraid that my mysql server is not configureed
properly. (I have redhat 7.2 os)


On Thu, 14 Mar 2002, Paul DuBois wrote:

> At 14:46 -0600 3/14/02, Todd Williamsen wrote:
> >I didn't realize you were trying to telnet to a client.  You cannot do
> >that.  You need to telnet to the SERVER.  Whatever the server is
> 
> He *is* telnet-ing to the server (port 3306 is the server port).
> But it doesn't make sense.  A Web server might be willing to speak
> ASCII to you.  The MySQL server is not.
> 
> >
> >You need to make sure the user you are trying to use has access rights
> >for the user for telnet
> >-----Original Message-----
> >From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, March 14, 2002 2:19 PM
> >To: Jianping Zhu
> >Cc: [EMAIL PROTECTED]
> >Subject: Re: problem in telent to mysql server
> >
> >
> >At 14:58 -0500 3/14/02, Jianping Zhu wrote:
> >>I use:
> >>telnet mysqlserverhostname 3306
> >>
> >>and get following response:
> >>
> >>   Host 'mylocalcomputer' is not allowed to connect to this MySQL server
> >>What does this mean? and how to fix the problem?
> >
> >The MySQL client-server protocol is a binary protocol.
> >It makes no sense to telnet to the server.
> >
> >>
> >  >Thanks
> 


--------------------------------
Jianping Zhu
Department of Computer Science
Univerity of Georgia 
Athens, GA 30602
Tel 706 5423900
--------------------------------


---------------------------------------------------------------------
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

Reply via email to