• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

SQL, access denied

 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 86
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You should provide more detailed information about your exception.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic