Problem connecting to mysql database

[Kelly]

Hey, Im pretty new to java and have been trying to connect to a sql database not on localhost. I keep geting the error

jdbc:mysql://websiteurl.com:3306/
java.sql.SQLException: Access denied for user 'myTESTusername'@'d58-110-200-85.mas9.nsw.optusnet.com.au' (using password: YES)

Process completed.

Ive changed the varibale which stores the username to "myTESTusername@websiteurl.com" but it keeps showing up as "'myTESTusername@'d58-110-200-85.mas9.nsw.optusnet.com.au" in the error message, does my internet provider optusnet blocking me or something?

Here is a copy of my code.

import java.sql.*; 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class websiteurlJDBCtest {
    public static void main(String[] args) throws Exception {
        websiteurlJDBCtest.useConnection();
    }
  	public static void useConnection() throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
	 	String URL = "jdbc:mysql://websiteurl.com:3306/";
	 	System.out.println(URL);
	 	String Database = "testDATABASE";
	 	String UserName = "myTESTusername@websiteurl.com";
	 	String Password = "myTESTpassword";  
	    Connection conn = null; // connection object
	    Statement stmt = null; // statement object
	    ResultSet rs = null; // result set object
	   	try {
	      	conn = DriverManager.getConnection(URL+Database,UserName,Password); 
			System.out.println("Connection Established");
	   	}
	   	catch(Exception e) {
	   		System.out.println(e);	
	   	}
  	}
}

I would really appriciate any help or ideas
thanx

[masijade]

That message is coming from the mysql, not your client, and you changing that "value" doesn't help as mysql will use the username and the actual hostname from which the connection was attemtpted from. You need to read the MySQL manual paying attention to the User Administration portions and, in particualr, the GRANT statement portion.

[Kelly]

I used cpanel to create the database, the user has all privledges to that database...

[FON]

Are you using some shared hosting for this?

Are you trying to connect from home PC to some remote
hosted MySQL?

Or both MySQL and your Java code are on same machine?

[Kelly]

the code and the mysql are not on the same machine, the database is hosted remotely, im just compiling the code on my home pc

[masijade]

The user has the rights, yes, I never said he didn't, but you also need to have user@host granted those rights, and seemingly you have them granted for one host, but the user is coming from another. That is what that message means. Read that portion of the manual again.

Edit: And don't say that "you know that's not the case", because you're wanting to change the username to "username@somehost" tells me that you don't understand it, at all.

[Md_Kayesh]

I made the following code. I have jdbc driver in mysql connector. i have added the directory to classpath variable. Then ran the following code with jcreator which shows the error:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver.
Then i tried with netbeans and it worked well. But i want to handle it manually. Anybody have any idea?? plz help...

import java.sql.*;

public class Connect
{
public static void main (String[] args)
{
Connection conn = null;

try
{
Class.forName ("com.mysql.jdbc.Driver");
String connectionUrl = "jdbc:mysql://localhost/mydatabasename" +
"user=root&password=mysecretpassword";
conn = DriverManager.getConnection (connectionUrl);
System.out.println ("Database connection established");
}
catch (Exception e)
{
System.err.println ("Cannot connect to database server");
e.printStackTrace();
}
finally
{
if (conn != null)
{
try
{
conn.close ();
System.out.println ("Database connection terminated");
}
catch (Exception e) { /* ignore close errors */ }
}
}
}
}

[r035198x]

What do you mean handle manually? Do you mean run from comamnd line?
If so then you should provide the -cp flag pointing to the mysql driver.

[masijade]

Start your own thread. That post is not related to the rest of this thread in any way, shape, or form. As hint "Classpath, Classpath, Classpath".

[masijade]

Oh God, not again. Stop posting this trash all over the place.

[hitesh]

how can i provide -cp flag pointing to the mysql driver??????????????

[Norm]

java -cp nameofjarfilewithmysqldriver.jar .....

[hitesh]

Yes I have the jar file. But i don't know how to install or where to copy that file
I use the code as follows-

public void Connect()

{

try

{

// Load the JDBC driver

String driverName = "com.mysql.jdbc.Driver";



Class.forName(driverName);



// Create a connection to the database

String url = "jdbc:mysql://127.0.0.1:3306/abc";

String username = "root";

String pass = "xyz";

con1=DriverManager.getConnection(url, username, pass);

}

catch (ClassNotFoundException e)

{



System.out.println("Connection Failed");

System.out.println(e);

}

catch(SQLException e)

{

System.out.println("Connection Failed1");

}



}

When I run this code I get the error-
Connection Failed
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:./], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}

[Norm]

When I run this code I

Can you show the command line you use when you "run this code"?
The java program can not find a class definition. The jar file containing that class definition must be on the classpath.

[hitesh]

Can you show the command line you use when you "run this code"?
The java program can not find a class definition. The jar file containing that class definition must be on the classpath.

I use the redhat Linux.
After running this code the messages are as follows

[root@server bhabani_press]# java NDitem
GTK Accessibility Module initialized
Connection Failed
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:./], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}

[Norm]

What jar file is the com.mysql.jdbc.Driver class in? Add that file to the classpath when using the java command:

java -classpath THEJARFILENAME.jar NDitem

[mcajavaprogramer]

set classpath in envoronment variable
path since mysqlconnector.jar
mysqlconnector.jar put into the lib folder

[mcajavaprogramer]

set classpath in envoronment variable
path since mysqlconnector.jar
mysqlconnector.jar put into the lib folder

[masijade]

No, do not "put it into the lib folder" (edit: if by that you mean the jre/lib/ext directory, if not, then expand on that, as alone, it means nothing, then). And don't try with the environment variable, that is used by almost nothing, anymore.