aspose file tools*
The moose likes JDBC 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


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySql and Tomcat connect with root, but not other user" Watch "MySql and Tomcat connect with root, but not other user" New topic
Author

MySql and Tomcat connect with root, but not other user

Wendy Bossons
Greenhorn

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.

..\Wendy
Nishan Patel
Ranch Hand

Joined: Sep 07, 2008
Posts: 684

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: 1506
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.

http://dev.mysql.com/doc/refman/5.1/en/adding-users.html


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySql and Tomcat connect with root, but not other user
 
Similar Threads
MySQL Linux Administration Question
Java MySQL connection
Petclinic of Spring2.5.6 with MYSQL and GLASSFISH
MySql Password error
strange problem when accessing MySQL