tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bjørge Solli <bjorge.so...@nersc.no>
Subject Re: erro jdbc connection with mysql
Date Thu, 05 Jan 2006 12:47:06 GMT
On Thursday 05 January 2006 13:33, marju jalloh wrote:
>  "...java.sql.SQLException: Data source rejected establishment of
> connection,  message from server: "Host 'localhost.localdomain' is not
> allowed to connect to this MySQL server..."

This is an "error" in your mysql privileges. Read up on it on mysql in the 
doc: 
http://dev.mysql.com/doc/refman/4.1/en/database-use.html
http://dev.mysql.com/doc/refman/4.1/en/grant.html

In short, run this as root inside mysql:
GRANT ALL PRIVILEGES ON your_db_name.* TO 'your_mysql_user'@'your_client_host' 
IDENTIFIED BY 'your_password';

-- 
Bjørge Solli - Office:+47 55205847 cellph.:+47 91614343
Nansen Environmental and Remote Sensing Center - Bergen, Norway
http://www.nersc.no Reception: +47 55205800
Dept.: Mohn-Sverdrup Center for Global Ocean Studies 
       and Operational Oceanography

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message