Take a look at the user accounts in MySQL. Some things to consider:
1. MySQL authenticates clients based on the host as well as username and password. Login to mysql manually and run this:
use mysql ; select user, host from user where user='root' ; If the host column has '%' or 'localhost.localdomain', it should work. 2. Using the root account in a webapp is not recommended. --David [EMAIL PROTECTED] wrote:
Hi, When we restarted tomcat, we are getting the below error while connecting to MySql database: --------------------- Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Access denied for user 'root'@'localhost.localdomain' (using password: YES) LifecycleException: Exception opening database connection: java.sql.SQLException: Accessdenied for user 'root'@'localhost.localdomain' (using password: YES) --------------------- Any work-around for the problem ? Thanks in advance. RK
--------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
