can't connect MySQL database

I’m trying to connect my data base but failed, Please help me out.
This is the error i’m getting:

ERROR MySQL Connector 2:1 Execute failed: Access denied for user ‘root’@‘localhost’ (using password: YES)

Hi there @shifa,

welcome to KNIME Community!

With same configuration you can successfully connect from other tools? Can you maybe share printscreen of Connector node? Additionally you can check Database Integration Guide to see if you have covered it all.

Br,
Ivan

Hi there @shifa,

can you try with MySQL Connector node? It should work with DB Connector as well but seems URL is a bit strange in your case. Root is both username and hostname? Usually localhost is hostname for MySQL database. Also seems you use MySQL version 5 JDBC driver while dedicated connector uses version 8.

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.