RE: mm.mysql question - Venu - com.mysql.lists.java

5 messages in com.mysql.lists.javaRE: 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:	RE: mm.mysql question
From:	Venu (ve...@mysql.com)
Date:	09/24/2001 09:24:14 PM
List:	com.mysql.lists.java

Hi Peter !!!

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.

Did you had a time to look in to the following section of the MySQL manual, which tells what are the reasons to get the Access denied error ? If not, here is the link: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#Access_denied

Also, The error message shows that you do no have the proper access privileges to connect to the server. For example if you are connecting as user 'me_as_jdbc_user' from the m/c 'mymachine' with passeword as 'mypasswd', execute the following query first in the server side with root privilages or appropraite way.

GRANT ALL ON *.* TO "me_as_jdbc_user"@"mymachine" IDENTIFIED BY "mypasswd"

This will grant access to me_as_jdbc_user from mymachine. If your Windoze machine has the IP "192.168.10.10", better use "me_as_jdbc_user@"192.168.10.10". If you want to connect from any sytem using the same user name use "%" instead of m/c name.

Here is the link for more information regarding the previlages: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management