views:

13

answers:

0

I juste installed mysql on my ubuntu box (lycid lynx) and try to connect to mysql trough java. Mysql is configured to allow only local connection. I can connect to mysql server with the mysql client locally and also i can with PHP. But from java no! I get this error "Host '....' is not allowed to connect to Mysql server". The address ip listed in the error is that assigned to my box by my ISP using a modem on ppp0. The ip addess of the loopback is 127.0.0.1 and eth0 has an ip address of 192.168.0.1. Some times i share my internet connection, thus i've enabled ip forwarding. First i think that the ip_forwarding was the problem so i've disabled it, but no lucky. Sincerely i don't userstand why JDBC try to connect to Mysql using the ip address of ppp0 in flavor to eth0 or lo. All suggestions are welcome.