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