up vote 0 down vote favorite
share [g+] share [fb]

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!

link|improve this question
60% accept rate
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
feedback

1 Answer

up vote 0 down vote accepted

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.

link|improve this answer
Will try, thanks! – David Mar 24 '10 at 12:32
feedback

Your Answer

 
or
required, but never shown
discard

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