File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQL, access denied Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL, access denied" Watch "SQL, access denied" New topic

SQL, access denied

Kari Nordmann
Ranch Hand

Joined: Feb 12, 2007
Posts: 38
I have built a scraper for two buddies of mine, and now I'm working on making the program upload the datas to the database.
While testing I am using my own database. I will be making the program so that one of my buddies will himself insert the required information for logging on to their server. That means I don't have access info to their database as of now.
When testing with my own server I keep getting the "Access denied" error. I am positive the user name, password and host is correct.
Googling this problem, all I can find is something about granting access to remote users on the server (it's not a firewall problem).

These two buddies of mine are not very experienced with programming, servers or databases. One of them has only basic computer knowledge, and the other has very limited knowledge of these things.
Thus, I would prefer to have my program be able to connect to their database with as little server fiddling as possible.

Is there any way I can make the program send the grant commands to the server by itself?
If not, could I make this java program execute a PHP script on the server, which in turn could do the uploading? I have never before built a program that executes anything outside itself.
Wei Dai
Ranch Hand

Joined: Jun 22, 2005
Posts: 86
You should provide more detailed information about your exception.
I agree. Here's the link:
subject: SQL, access denied
It's not a secret anymore!