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)
Next>
Host:
www.example.com
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:
Code:
!cannot establish a connection to jdbc:mysql://www.example.com:3306/university using com.mysql.jdbc.Driver (Access denied for user 'me'@'d-h-c-p.myisp.com' (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':
Code:
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.
