RE: problem in telent to mysql server
Can you telnet into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: problem in telent to mysql server 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? Thanks - 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 - 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
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 - 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
RE: problem in telent to mysql server
On Thu, 14 Mar 2002, Todd Williamsen wrote: telbet to webserer is OK, I use telnet thesamename 80 get following messge !DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN HTMLHEAD TITLE501 Method Not Implemented/TITLE /HEADBODY H1Method Not Implemented/H1 M to /inde .htm not supported.P Invalid method in request MP HR ADDRESSApache/1.3.2 Server at A HREF=mailto:root@localhost;_default_/A Port 80/ADDRESS /BOD /HTML Can you telnet into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: problem in telent to mysql server 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? Thanks - 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 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
RE: problem in telent to mysql server
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 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 - 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 - 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
RE: problem in telent to mysql server
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 - 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
RE: problem in telent to mysql server
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
RE: problem in telent to mysql server
Thanks for your advices. In the offical mysql webpage, there is a paragraph tell us how to usinng telnet test mysql server connectivity. That test tells you only whether or not there's a MySQL server listening on the port. It doesn't tell you that you should actually try to communicate with the server in any way. If the server is running and you're having problems establishing a connection to it using a program that actually uses a client-server API (like a JDBC driver), then the problem is that the grant tables don't have an entry for the MySQL user and password that you're supplying. You might find it easier to perform your testing by using the mysql client program from the command line. --- 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) - 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
RE: problem in telent to mysql server
Howdy - You are trying to telnet to the MySQL server. 3306 is the MySQL Server default port, not the telnet port. If you are trying to run the MySQL client, then: 1) telnet mysqlserverhostname 2) run the Mysql client within your telnet session (mysql -uroot -proot, for example) If you are trying to access the MySql server programatically, then you need to have your code go the libmysqlclient or whatever library and use the appropriate API. Regards, Ken -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: problem in telent to mysql server 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? Thanks - 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 - 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