DriverManger.getConnection

[mransome]

I am trying to connect to a MySQL DB on a linux server from a Java App on a win32 pc. I suspect I am not writing the url properly.

here is the code:

Connection con = DriverManager.getConnection("jdbc:mysql://paptais07:3306/test" , "root", "");

here is the error:

java.sql.SQLException: Access denied for user 'root'@'pc5033.petrotrin.com' (using password: NO)

pc5033 is my pc and petrotrin is the domain it is in.

any help will be much appreciated.

[shanePreater]

Your problem is the user credentials that your passing.
Have you setup the root user without a password and set the host to any (*)?
Normally with a default install of MySQL you specify a root password and by default only local connections can use the root account.
Check out The main MySQL section
Also this guide on devshed might help.

That should get you moving again.
Shane.