[Ghazalawahid]

How can i specify a password of my local database in a url below?

url = “jdbc:mysql://localhost:3306/Northwind”;

[Haris Peco]

Ghazalawahid ,

try

url = “jdbc:mysql://localhost:3306/Northwind?user=YOUR_USERNAME&password=YOUR_PASSWORD”;

see http://dev.mysql.com/doc/refman/5.0/en/cj-configuration-properties.html for complete url syntax

Regards

[Ghazalawahid]

My code for Database access is :

String driver = “com.mysql.jdbc.Driver”;
String url = “jdbc:mysql://localhost:3306/Northwind”;
String username = “”;
String password = “ghazala”;

But having error :

String driver = “com.mysql.jdbc.Driver”;
String url = “jdbc:mysql://localhost:3306/Northwind”;
String username = “”; // No username/password required
String password = “ghazala”; // for desktop access to MS Access.
showEmployeeTable(driver, url, username, password);

” Error with connection: access denied for user ‘ ‘@’ localhost’

[Ghazalawahid]

I have pasted the code twice in above question,hope its understandable.

[Haris Peco]

Ghazalawahid ,

You can’t access to MS Access with mysql driver

Regards

[Author]

Posts