File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes MySql and Tomcat connect with root, but not other user Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySql and Tomcat connect with root, but not other user" Watch "MySql and Tomcat connect with root, but not other user" New topic

MySql and Tomcat connect with root, but not other user

Wendy Bossons

Joined: Sep 04, 2009
Posts: 3
Issue: I can connect to my database using root, but not with any other MySql user. Specifically the issue is occurring when the web application is querying the database. The content which is database driven is empty with any other user.

Environment is Tomcat 6
MySql 5.X
JSF Web Application

I have created a DAO structure. I can ping the database using root, and even with my other user, let's call that user Sam.

So I then changed the username and password in the context.xml and in the server.xml to be Sam and SamsPassword. I can ping the MySql database from Eclipse, but when I deploy to the localhost, and enter the url in a browser, the content is empty. A look at the error log in Tomcat shows access is denied. "com.lavaflow.dao.DAOException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'Sam'@'localhost' (using password: YES))"

I am running into a wall on this . . . cannot construct a decent query result from google, so I'm hoping JavaSaloon gurus can help.

Nishan Patel
Ranch Hand

Joined: Sep 07, 2008
Posts: 689

Hi Wendy,

welcome to java ranch...

have you try to access database using MySql Query browser with new user name and password.
check using MySql Query browser with Sam and SamsPassword. If you are access to database then you can access from your application.

And also check that user Sam and SamsPassword access privileged to the MySql database..

Thanks, Nishan Patel
SCJP 1.5, SCWCD 1.5, OCPJWSD Java Developer,My Blog
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
Exactly, you will need to make sure that the user does have previledge to access the database. If you have not granted access for the user you can see this link on how to do it.

So much trouble in the world -- Bob Marley
I agree. Here's the link:
subject: MySql and Tomcat connect with root, but not other user
It's not a secret anymore!