Java Database mySQL access denied

Question

So I am trying to connect to my database and display an item from the table. The error I am getting is: SQL Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'Bob'@'%' to database 'TEST'

Is this connecting properly, and if so is the error that the credentials are wrong? And if they are wrong how is it connecting? Thank you

try 
     {  
        Class.forName("com.mysql.jdbc.Driver");        
        String url = "jdbc:mysql://THISISTHEHOSTNAME";
        String username = "Bob";
        String password = "password";
        Connection connection = DriverManager.getConnection(url, username, password);
         Statement stmt = null;
        ResultSet rs = null;
        //SQL query command
        String SQL = "SELECT * FROM TEST";
        stmt = connection.createStatement();
        rs = stmt.executeQuery(SQL);
        while (rs.next())
        {
            System.out.println(rs.getString("ProductName") + " : " + rs.getString("UnitPrice"));
        }
     } 
     catch (SQLException e) 
     {
        System.out.println("SQL Exception: "+ e.toString());
     } 
     catch (ClassNotFoundException cE) 
     {
        System.out.println("Class Not Found Exception: "+ cE.toString());
     }

Yes it's connecting, but it's not logging in because the credentials are wrong. — Dan Bracuk
– Dan Bracuk, Commented Jan 21, 2014 at 17:16

watIzZiss · Accepted Answer · 2014-01-21 17:28:26Z

7

You need to grant the proper privileges to the user that is connecting to the mysql db.

The message you are getting is informing you that while your user was able to connect to the database server, it was not allowed to access the database TEST.

Running the following command in the mysql console would grant such access:

GRANT ALL ON TEST.* TO 'BOB'@'%'

This is extremely permissive and you should keep in mind that db users should have the minimal amount of privileges possible and be restricted to the smallest range of hosts.

answered Jan 21, 2014 at 17:28

watIzZiss

813 bronze badges

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

1 Comment

user3211740 Over a year ago

MySQL said: Documentation #1044 - Access denied for user 'BOB'@'%' to database 'TEST'

user4294909 · Accepted Answer · 2015-12-17 03:57:17Z

0

I used ShowIP Firefox add on and used the IP instead and didn't get any errors but I'm wondering if should return access granted and I'm unable to find an answer at the moment.

answered Dec 17, 2015 at 3:57

community wiki

user4294909

Comments

Programmer · Accepted Answer · 2014-01-21 17:20:39Z

-1

Here's a few things to do:

Check to see if your username and password are correct.
Did you add the username to the correct database? (This needs to be done in CPanel SQL)
Did you allow your database to get connection access from your IP address? (This also needs to be done in CPanel SQL)

answered Jan 21, 2014 at 17:20

Programmer

1122 gold badges2 silver badges7 bronze badges

5 Comments

Dan Bracuk Over a year ago

Downvoted because this does not answer the question.

user3211740 Over a year ago

I am using a godaddy database, the username and password are the ones I supplied when creating it.

Programmer Over a year ago

Did you put the username in the database and give it privileges? Like this: website-in-a-weekend.net/wp-content/uploads/2010/03/…

user3211740 Over a year ago

There is no option for creating users for the database. Just the log in credentials?

Programmer Over a year ago

I don't know how to give user privileges without adding it to the database (I've never used godaddy database). Please look at waltzZiss's suggestion, I think he's correct.

tobizzz · Accepted Answer · 2016-03-18 07:50:33Z

-1

create a new user in mysql check all global privileges > go to service in netbeans > database > mysql server at localhost > right click connect and fill username password

this work for me

answered Mar 18, 2016 at 7:50

tobizzz

112 bronze badges

1 Comment

tobizzz Over a year ago

create a new user with all privileges and connect it with netbeans

Eray Balkanli · Accepted Answer · 2018-03-05 18:00:48Z

-1

Please try the code below:

import java.sql.*;
public class InsertPrepared {

   public static void main(String[] args)
   {
      try
      {
         Class.forName("com.mysql.jdbc.Driver");
         Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306//test","sanjib","");
         PreparedStatement stmt=con.prepareStatement("insert into employee values(???)");

         stmt.setInt(1,101);
         stmt.setString(2,"Sampa");

         int i=stmt.executeUpdate();
         System.out.println(i+"Records is inserted");
         con.close();
      }

      catch(Exception e)
      {
         System.out.println(e);
      }

   }
}

edited Mar 5, 2018 at 18:00

Eray Balkanli

8,04013 gold badges60 silver badges94 bronze badges

answered Mar 5, 2018 at 17:06

Sanjib Giri

1

1 Comment

Sanjib Giri Over a year ago

I am not getting proper answer when I'm run then com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database '/test' show and not uodate in database

Collectives™ on Stack Overflow

Java Database mySQL access denied

5 Answers 5

1 Comment

Comments

5 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

5 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related