Re: erro jdbc connection with mysql

2006-01-05 Thread Bjørge Solli
On Thursday 05 January 2006 15:42, marju jalloh wrote: >> Rafal Zawadzki <[EMAIL PROTECTED] >> > Bjørge Solli wrote: > 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'; >> >> FLUSH ... >

Re: erro jdbc connection with mysql

2006-01-05 Thread marju jalloh
I made it thanks to Rafal Zawadzki and Bjørge Solli The solution was to grant permision to hostname and not localhost of ip address Once more thanks Rafal Zawadzki <[EMAIL PROTECTED]> wrote: > In short, run this as root inside mysql: > GRANT ALL PRIVILEGES ON your_db_name.* TO > 'your_mysql_us

Re: erro jdbc connection with mysql

2006-01-05 Thread Bjørge Solli
On Thursday 05 January 2006 13:57, Rafal Zawadzki wrote: > > 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'; > > FLUSH ... Not necessary when using GRANT, only necessary if you edit the

Re: erro jdbc connection with mysql

2006-01-05 Thread Rafal Zawadzki
> 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'; FLUSH ... -- Rafał Zawadzki Deploy/Release Manager eo Networks Sp. z o.o. pgp0C6HJ5wXNi.pgp Description: PGP signature

Re: erro jdbc connection with mysql

2006-01-05 Thread Bjørge Solli
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

Re: erro jdbc connection with mysql

2006-01-05 Thread Rafal Zawadzki
> GRANT ALL PRIVILEGES on yourdatabase.* TO 'youruser'@'yourhostnametomcat' > IDENTIFIED BY 'yourl33tpassword'; Oh, I forgot. After this you should: FLUSH PRIVILEGES; -- Rafał Zawadzki Deploy/Release Manager eo Networks Sp. z o.o. pgpPRFhyiG4SB.pgp Description: PGP signature

Re: erro jdbc connection with mysql

2006-01-05 Thread Rafal Zawadzki
### marju jalloh <[EMAIL PROTECTED]> wrote message to Tomcat Users List ### ### this is reply for: erro jdbc connection with mysql ### > Hi everyone, > > I`m trying to connect to mysql from jdbc but I freequently get this errror > > "...java.sql.SQLException: Data sou

erro jdbc connection with mysql

2006-01-05 Thread marju jalloh
Hi everyone, I`m trying to connect to mysql from jdbc but I freequently get this errror "...java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'localhost.localdomain' is not allowed to connect to this MySQL server..." env linux debian(serge) j