Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Database Connectivity >> Java Database Connectivity (JDBC)

Illegal connection port value for mysql/netbeans

I have a problem here connecting to mysql database from netbeans.. tried to uninstall and reinstall but still the same problem.. i have the connector file and these are the steps followed:

1. Launch netbeans 5.5 and click on Runtime and right-click on Databases.

2. Select New Connection and click Add to find the .jar file from the connector folder. Then click OK to return to New Database Connection screen

3. Click OK to connect. BUT an error message pops up saying "Unable to add connection, cannot establish a connection to jdbc:mysql://<HOST>:<PORT>/<DB> using com.mysql.jdbc.Driver (Illegal connection port value'<PORT>')"

what should i do to solve this problem? help needed ASAP.. thank you..

[757 byte] By [nastassjaa] at [2007-11-27 8:20:10]
«« Overriding final for assignment?
»» help with and animation
# 1
It would seem you have a connection URL that is actually jdbc:mysql://<HOST>:<PORT>/<DB>You need to replace the values in < > with your actual values.
cotton.ma at 2007-7-12 20:08:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

i've replaced all values for host, port and db and but it doesn't work. instead another error popped up saying "communications link failure due to underlying exception etc etc"..plus a whole bunch of stacktrace.. why does this happen?

i tried this line at the database URL- jdbc:mysql//localhost:3306/fyp and the error message is access denied for user ''@'localhost'(using password NO)

i'm using netbeans 5.5 and mysql server 5.0..in another laptop i only used this line - jdbc:mysql//<HOST>:<PORT>/<DB> and it there wasn't a problem.. i was able to connect to the intended db..

nastassjaa at 2007-7-12 20:08:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
Database Connectivity
Java Database Connectivity (JDBC)

Database Connectivity Hot Topic

Database Connectivity

All Classified