To prevent spam users, you can only post on this forum after registration, which is by invitation. If you want to post on the forum, please send me a mail (h DOT m DOT w DOT verbeek AT tue DOT nl) and I'll send you an invitation in return for an account.

Unable to Test MySQL Connection in XESame

ashish
edited July 2013 in - XESame

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

Answers

  • 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.
    Joos Buijs

    Senior Data Scientist and process mining expert at APG (Dutch pension fund executor).
    Previously Assistant Professor in Process Mining at Eindhoven University of Technology
  • 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

Sign In or Register to comment.