0

I have deployed an application on my Tomcat server with JDBC resources defined. What is puzzling me is that I can connect to the database (which is running locally on the server) only using the server's IP. When I change the resource host to localhost (or 127.0.0.1) then MySQL rejects the connection. I don't want to be connection via the server's IP but rather locally.

What do I do?

Thanks!

  • Which Operating System? Are you using a firewall? Which interfaces is MySQL listening on? – Chris Lercher Mar 22 '10 at 14:45
  • That is on Ubuntu. I am using firewall but 3306 is open - I can connect to the MySQL server from outside via the server's IP. The problem is that Tomcat only connects to MySQL using the server's IP and not localhost. – David Mar 24 '10 at 10:50
0

MySQL treats localhost connections and 127.0.0.1 connections and '%' connections differently. Your user needs to be granted access specifically to connect to localhost or 127.0.0.1 or both.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.