JDBC: Can't access DB that I can get with MySQL Workbench
Posted by: Mark Meyers
Date: December 15, 2015 01:58PM

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'

Options: ReplyQuote

Written By
JDBC: Can't access DB that I can get with MySQL Workbench
December 15, 2015 01:58PM

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.