• 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
  • Junilu Lacar
  • Liutauras Vilda
Sheriffs:
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
Bartenders:
  • Jesse Duncan
  • Frits Walraven
  • 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
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic