Java SQL Connection Not Functioning

Question

When I make a connection to my MYSQL database (hosted on phpmyadmin on a domain with hosting, not localhost), I receive an error that I'm denied access to the server entirely. What is going on? I'm not extremely familiar on how to use this libraries methods and am confused.

Connection connection;
try 
{
   connection = 
  DriverManager.getConnection("jdbc:mysql://WEBSITENAME.com/DATABASENAME0", 
   "DATABASEUSERNAME", "DATABASEPASSWORD");
   Statement sql = connection.createStatement();
   ResultSet myRs = sql.executeQuery("SELECT * FROM table");

while(myRs.next()) 
{
  System.out.println(myRs.getString("column"));
}

} catch (SQLException e) 
{
   e.printStackTrace();
}

The error provided is as follows:

java.sql.SQLException: Access denied for user 'user'@'IP ADDRESS IS LISTED HERE' (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at jDgmj8pWUnXVoHZk04z9.sqlConnect.updateCommand(sqlConnect.java:12) at jDgmj8pWUnXVoHZk04z9.Driver.main(Driver.java:10)

Schnielz · Accepted Answer · 2019-05-23 14:14:45Z

0

I have two ideas for this:

Normally you MySQL denies connections from other hosts. You have to configure that in the configuration file (see here). If you can not access the configuration file you will have to ask your admin.
Additionally you should check if the port 3306 (MySQL default port for TCP connections) is even opened. If the firewall blocks that port you will not be able to connect. In Windows you could check it with telnet (if enabled):

.

telnet WEBSITENAME.com 3306

No error message (blank cmd) means connection is established.

answered May 23, 2019 at 14:14

Schnielz

612 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Schnielz Over a year ago

That looks like an answer from the server. This tells us that you where able to establish a TCP connection to the host on the used port. The problem is then in your MySQL configuration. See # 1. in my answer or justins answer.

David Mendez Guardado · Accepted Answer · 2019-05-23 14:15:50Z

0

Maybe one of the problem is the Server, check that the user is allowed to connect from outside the localhost, or check if you user is allowed to connect like this: user@IPAddress

answered May 23, 2019 at 14:15

David Mendez Guardado

401 silver badge7 bronze badges

1 Comment

user2451511 Over a year ago

When I do telnet I get this message any clue as to what this means: imgur.com/a/va0DurL

Justin · Accepted Answer · 2019-05-23 14:36:00Z

0

Common problem for hosted services, like hosted DBs/DBaaS nowadays. Many hosting providers default to DENY ALL and expect that no DB connections are allowed inbound from anonymous Internet IPs, aka. anything outside (a) their platform or (b) outside their subnet(s).

If the other recommended tests don't work (like telnet), ask your DB provider if they maintain a whitelist and how they provide exception. This is usually done via a self-service ticketing system for many hosting providers.

Or can you co-host your Java app on that same hosting provider? like via a basic VM/instance on the same subnet as the DB instance?

answered May 23, 2019 at 14:36

Justin

213 bronze badges

1 Comment

user2451511 Over a year ago

When I use telnet I get this message do you know what this means? imgur.com/a/va0DurL

Collectives™ on Stack Overflow

Java SQL Connection Not Functioning

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related