jdbc connection godaddy mysql java

Question

I have checked most of the comments for this problem and still couldn't work it out. I am using eclipse and writing the program with java, I have successfully established connections to my local SQL and everything was working

Now I am trying to connect to a DB in the goDaddy service

I am using the following format

private String conUrl = "jdbc:mysql://someIP:3306/DBname"; 
private String userName = "userName123";
private String pw ="userName123Password";

private static Set<Connection> conSet = new HashSet<Connection>();
public final int max_Con =5;
public static Object key = new Object();

private ConnectionPool() throws ClassNotFoundException, SQLException {

    Class.forName("com.mysql.jdbc.Driver");  
   //    java.sql.Driver test = DriverManager.getDriver(conUrl);
   //   System.out.println(test);


    for (int i = 0; i < max_Con; i++)
    {
        Connection con = 
        DriverManager.getConnection(conUrl,userName,pw);    
        conSet.add(con);
    }

Where the username and its password is registered to the specific DB granted with all privileges.

I get an exception of the following

Exception in thread "main" java.sql.SQLException: Access denied for user 'userName123'@'myIPadress.cablep.bezeqint.net' (using password: YES)

Did anyone encounter this problem?

I should mention that bezeqint.net is my internet supplier and a friend of mine did get a connection using a php application with the same DB.

i forgot to insert the imports: import java.sql.Connection; import java.sql.DriverManager; — Orchay, Oct 01 '17 at 13:56
are you sure, you are able to connect to database using same username and password ? — Ravi, Oct 01 '17 at 13:57
import doesn't matter as your are getting error from your database. — Ravi, Oct 01 '17 at 13:57
mySQL has few form to grant rights, for local acces simpler, for remote must add few parameters more. — Jacek Cz, Oct 01 '17 at 14:00
since i wasnt sure about the previous username and password i created a new 1 and double checked it — Orchay, Oct 01 '17 at 14:02
is there a way to check if there is a connection attempt such as get available DB names within the host ip? — Orchay, Oct 01 '17 at 14:03

jdbc connection godaddy mysql java

0 Answers0