-   Programming (
-   -   NetBeans 7 connection to remote MySQL database (

Vitus13 11-19-2011 02:37 PM

NetBeans 7 connection to remote MySQL database
I swear I had this working 3am last night, today I woke up and it wasn't working.

In Netbeans 7.0.1 (which I am not fond of, but have to use for this project), I goto the 'Services' pane and right click on 'Databases'. I select "New Connections..." and in the dialog that opens I fill in the following information:

Driver: MySQL (Connector/J driver)
Port: 3306
Database: university
User: me
Password: XXXXXXXX

Then I test the connection. I know it was working last night (early this morning), however currently I get this error:

!cannot establish a connection to jdbc:mysql:// using com.mysql.jdbc.Driver (Access denied for user 'me'@'' (using password: YES))
I can connect to the server via putty and log into the mysql database. Below are the permissions set for the user 'me':

mysql> select user, host, db, select_priv SEL,insert_priv INS, update_priv
 UPD, delete_priv DEL,create_priv CRT, drop_priv DRP,index_priv IDX, alter_priv
 ALT, show_view_priv SHW from mysql.db where user='me';
| user | host | db        | SEL | INS | UPD | DEL | CRT | DRP | IDX | ALT | SHW |
| me  | %    | university | Y  | Y  | Y  | Y  | Y  | Y  | Y  | Y  | N  |
1 row in set (0.00 sec)

I don't think it's a permissions issue, since I was creating tables in that database from netbeans last night.

All times are GMT -5. The time now is 12:18 PM.