Then in the Data Source Explorer window I configured a datasource using the above driver and:
User name: someuser
Testing the connection results in a successful ping. Changing any of the properties to an invalid value results in a ping failure, so I know I am not getting a false positive and that Eclipse really can connect to the database. In addition, I can see the connections in MySQL Administrator.
But, in the Data Source Explorer, when I expand the datasource using "somedb > schemas > somedb > tables", there are no tables showing, yet the database does have tables.
By the way, I have tried the URLs both with (e.g., jdbc:mysql://localhost:3306/somedb) and without (e.g., jdbc:mysql://localhost:3306/) the database name, in both the driver and datasource definitions; a post I found on another site recommended not placing the database name in the driver URL, but that was for Eclipse 3.3 and 5.0.6 MySQL connector.
Does anybody know how to get MySQL properly configured in Eclipse? Actually, I would ignore this (my app works fine), but I have some JPA entity beans and the red underlines are driving me batty.