5 messages in com.mysql.lists.javaFW: mm.mysql question| From | Sent On | Attachments |
|---|---|---|
| Peter Abplanalp | 24 Sep 2001 13:54 | |
| Peter Abplanalp | 24 Sep 2001 18:55 | |
| Venu | 24 Sep 2001 21:24 | |
| Peter Abplanalp | 25 Sep 2001 06:03 | |
| Venu | 25 Sep 2001 11:03 |
| Subject: | FW: mm.mysql question |
|---|---|
| From: | Peter Abplanalp (pt...@psaconsultants.com) |
| Date: | 09/24/2001 06:55:15 PM |
| List: | com.mysql.lists.java |
i'd like to thank everyone who responded to my question. most responses where like the one below. i.e. check my user and its permissions. i have done this and the user appears to be fine. i can connect to the mysql database using the mysql client. in that user's database i can create tables, etc; however, when i try to connect using mm.mysql with the same user and password, i get the error i mentioned in my original email. any additional thoughts would be appreciated.
-----Original Message----- From: Ylan Segal [mailto:yl...@digiworks.tv] Sent: Monday, September 24, 2001 7:40 PM To: Peter Abplanalp Subject: RE: mm.mysql question
Make sure that you have appropiate permissions to connect. I have found that the mm.mysql driver tries to connect using the machines name, not localhost, (ie some.server.com). Are you sure that your user has permission to connect from some.server.com? Chechk with show grants for your...@some.server.com
Hope it helps.
Ylan Segal.
-----Original Message----- From: Peter Abplanalp [mailto:pt...@psaconsultants.com] Sent: Monday, September 24, 2001 2:55 PM To: ja...@lists.mysql.com Subject: mm.mysql question
i am using mm.mysql version 2.0.5 and mysql version 3.23.42. i am trying to make a connection but am getting the following error message: "SQLException: Invalid authorization specification: Access denied for user 'pics@yoda' (Using password: YES)" i have tried to connect both remotely and from localhost with no success. i have also tried the root user as well as the on in the message.
can anyone tell me what the problem is? thanks!
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.