When we restarted tomcat, we are getting the below error while connecting to MySql database

[rk...@smxbox.com]

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

Re: When we restarted tomcat, we are getting the below error while connecting to MySql database

[David Smith <dn...@cornell.edu>]

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

rk@smxbox.com 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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org