JDBC: Can't access DB that I can get with MySQL Workbench
I am having trouble connecting to my datasource using JDBC. I have a database server running on a bluehost machine, and I am giving myself remote IP access via my IP address.
On my client machine, I have MySQL Workbench, and some Java code. MySQL workbench is getting the connection, using the database that I would like it to. With the driver manager connection, I cannot specify my database, such as with a forward slash after the port # in the URL, or it will give a connect error.
I can get the connection with the same userid and password using Workbench or the driver manager, but with JDBC it doesn't want to give me access to the same database, I think.
When I try to execute this: "use database", I get:
Access denied for user 'userid'@'184.11.22.%' to database 'database'
Subject
Written By
Posted
JDBC: Can't access DB that I can get with MySQL Workbench
December 15, 2015 01:58PM
December 15, 2015 02:02PM
December 15, 2015 03:50PM
December 15, 2015 04:54PM
December 15, 2015 05:25PM
December 15, 2015 06:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.