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)

Re: erro jdbc connection with mysql

2006-01-05 Thread Rafal Zawadzki
### marju jalloh [EMAIL PROTECTED] wrote message to Tomcat Users List users@tomcat.apache.org ### ### 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 source rejected

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 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 it on

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: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 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 ... I made it thanks