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

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
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic