I just got started with KNIME. I have a MySQL database on my PC, and want to connect KNIME to the db so that I can work with the tables. I can't connect with the db. I've configured the KNIME db reader using both jdbc:mysql://localhost:3306/mydb and jdbc:mysql://127.0.0.1:3306/mydb, but I get the error message: WARN Database Reader java.sql.SQLException: org.knime.core.node.InvalidSettingsException: Driver "sun.jdbc.odbc.JdbcOdbcDriver" does not accept URL: jdbc:mysql://localhost:3306/mydb. I'm using the driver sun.jdbc.odbc. JdbcOdbcDrive. What am I doing wrong?
- Use Cases