Unable to Test MySQL Connection in XESame

ashish

I am unable to Test MySQL
Connection in XESame

URL to Database: jdbc:mysql://localhost:3306/dbname

JDBC Driver: com.mysql.jdbc.Driver

JDBC Driver Location: C:\TOOLS\ConnectorJ\mysql-connector-java-5.1.25\mysql-connector-java-5.1.25-bin.jar

In Connection properties I
entered the username and password for root user –

I am getting an error message:  “Sorry
the test failed because the URL could not be found. Access denied for user “@”
localhost (using password: YES)” 

Thanks in advance

JBuijs

Dear ashish,

Did you enter the password in the URL or in the properties field?
If there is no login required, empty the property fields 'name' and 'password' (the row will be removed automatically) and try again.

Please let me know if this works.

ashish

Thanks for the reply. It
worked – following is the solution so that it is helpful for others facing
similar problem.

I emptied the connection
properties field (property and value fields - blank)

Included username and password in
the URL in the following way

jdbc:mysql://localhost:3306/mozilla?user=root&password=mypassword

JDBC Driver: com.mysql.jdbc.Driver