I used port 3307 because I thought it was a problem with that port. Anyway, I have set everything back to default. Now mysql is on port :3306 and my jsp refers to it on that same port but the problem still persists
- can you connect to localhost 3306 with telnet (to check if DB is up) - try to replace localhost with 127.0.0.1 or the machine name/ip ? - do you have any software firewall which could cause this ? - did you modify java's security settings to deny access (i swapped in the wrong policy file once and searched for the "bug" for a longlong time ;-) )
Joined: Apr 03, 2004
its working now! Thanks all. very much appreciated.
"schrodinger's cat", We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
I have the same problem. Here is the answere to most of the previous questions:
Yes, I can connect from prompt without problems No, I can't connect via telnet (should that be possible?), not even from the localhost (tryed ip, hostname and localhost) No, I can't connect from mysqlCC from another machine.
The daemon is running (otherwise I wouldn't be able to connect at all and I am).