Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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!

share|improve this question
    
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
add comment

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.

share|improve this answer
    
Will try, thanks! –  David Mar 24 '10 at 12:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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