20 messages in com.mysql.lists.javaRe: MM JDBC Driver with MySQL| From | Sent On | Attachments |
|---|---|---|
| Lawrence, Gareth | 25 Mar 2002 18:56 | |
| Lawrence, Gareth | 25 Mar 2002 20:09 | |
| Fabian Sommer | 26 Mar 2002 01:40 | |
| Rakesh | 26 Mar 2002 02:10 | |
| Fabian Sommer | 26 Mar 2002 03:38 | |
| Fabian Sommer | 26 Mar 2002 04:15 | |
| Adnan Al-bar | 26 Mar 2002 04:43 | |
| Leo Przybylski | 26 Mar 2002 07:19 | |
| Mark Matthews | 26 Mar 2002 10:03 | |
| Mark Matthews | 26 Mar 2002 10:08 | |
| Tom Myers | 26 Mar 2002 12:53 | |
| Bruce Scharlau | 26 Mar 2002 13:00 | |
| Lawrence, Gareth | 26 Mar 2002 13:36 | |
| Bruce Scharlau | 26 Mar 2002 13:59 | |
| Mark Matthews | 26 Mar 2002 14:33 | |
| Bruce Scharlau | 26 Mar 2002 16:01 | |
| Bruce Scharlau | 26 Mar 2002 16:27 | |
| Tom Myers | 26 Mar 2002 18:08 | |
| Tye, Timothy | 27 Mar 2002 11:38 | |
| Fabian Sommer | 10 Apr 2002 23:56 |
| Subject: | Re: MM JDBC Driver with MySQL |
|---|---|
| From: | Mark Matthews (mmat...@thematthews.org) |
| Date: | 03/26/2002 10:08:06 AM |
| List: | com.mysql.lists.java |
----- Original Message ----- From: "Leo Przybylski" <le...@engr.arizona.edu> To: "Lawrence, Gareth" <G.R....@massey.ac.nz>; <ja...@lists.mysql.com> Sent: Tuesday, March 26, 2002 9:20 AM Subject: Re: MM JDBC Driver with MySQL
Well, some of the mysql tools are native code which can connect to the database server without going through localhost 3306. So, if your server is up and you are able to connect with it using your tools that doesn't necessarily mean it is running on 3306. I would try to telnet to 3306. Immediately, you should see something like: ( 3.23.45(b5~=Uq\X
Leo is absolutely correct. If your MySQL server has been started with the "--skip-networking" flag, it will only accept connections via named pipes (windows) or unix domain sockets (Unix), neither of which Java has access to. If your MySQL server is running on a non-standard (not 3306) port, then you have to tell MM.MySQL what port the server is running on using the :[port-no] part of the URL.
The easiest test to do is the telnet test that Leo outlines. Telnet to port 3306 on the machine you're trying to connect to. If it doesn't immediately respond with some garbage including a MySQL version number, then you have a configuration issue. Read (or hopefully re-read) the MySQL server manual, and get your server setup to take TCP/IP connections on the standard port.
-Mark