Hi,
I am having trouble coding a basic application to retrieve some data from a database I have.

For reference, the database host is 'saurabhs.wv.cc.cmu.edu'
The client is 'go.ece.cmu.edu'

I have already set up the mySQL driver Connector/J (verified this).

I am gettin the following error when I try to

conn = DriverManager.getConnection("jdbc:mysql://saurabhs.wv.cc.cmu.edu/supari","root","*****");

where 'supari' is the name of the database i wish to access and root and ***** are the user/password for the database and it has been setup in the user table.

SQLException: Invalid authorization specification, message from server: "Access denied for user: 'root@GO.ECE.CMU.EDU' (Using password: YES)"
SQLState: 28000
VendorError: 1045

so, it seems like it is trying to get root access to go.ece.cmu.edu instead of at saurabhs.wv.cc.cmu.edu.

any suggestions?

Thanks,
Saurabh Sharma

Hi,
Make sure that db access from hosts other than localhost is enabled in your mysql server. You know, it is possible to restrict access based on hosts and/or users in mysql.
Ilker