• 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:
  • Campbell Ritchie
  • Devaka Cooray
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Jeanne Boyarsky
  • Tim Cooke
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
Bartenders:

ERROR 1044: Access denied for user 'username@%' to database 'db_name'

 
Ranch Hand
Posts: 250
Android Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Ranchers

I am trying to connect my web service with the database running on server.
Following is the code.


Doing this i'm getting following exception on line 2

java.sql.SQLException: null, message from server: "Host '115.115.119.34' is not allowed to connect to this MySQL server"

To resolve this I tried runnig the command in phpMyAdmin-

"GRANT ALL PRIVILEGES ON db_name .* TO 'username'@'%' IDENTIFIED BY 'password'"

on server by the getting error-

1044: Access denied for user 'username@%' to database 'db_name'

I tried a lot but not getting any way to resolve this error. Please help me resolving this issue.
Thanks in advance for your humble replies.
 
Astha Sharma
Ranch Hand
Posts: 250
Android Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please answer my question if someone knows anything about it. I am waiting for replies.
Thanks in advance
 
And will you succeed? Yes you will indeed! (98 and 3/4 % guaranteed) - Seuss. tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic