This week's book giveaway is in the Other Open Source APIs forum. We're giving away four copies of Storm Applied and have Sean Allen, Peter Pathirana & Matthew Jankowski on-line! See this thread for details.
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.