LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   NetBeans 7 connection to remote MySQL database (http://www.linuxquestions.org/questions/programming-9/netbeans-7-connection-to-remote-mysql-database-914418/)

Vitus13 11-19-2011 01: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)
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.


All times are GMT -5. The time now is 03:21 PM.