Connecing to MySQL on a PC

HGLuterMusic

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?

Comments
Sat, 09/25/2010 - 05:09

Hi,

Are you registred MySQL driver at File->Preferences->KNIME->DataBase Driver page? If registred, are you select this driver when configure node in Database Driver list at the top of "Settings" tab?

Hope, it helps,

Max

Sat, 09/25/2010 - 06:51
Thanks Max. It's getting better. I have the driver listing now. I connect to the database via TCP/IP. How do I enter that protocol? It did not work when I used TCP/IP or TCPIP.
Sat, 09/25/2010 - 07:18

Sorry, can you give more info? Where are you use tcpip word?

Are you test connection with connection string (database url) from first post? 

In the first post you are used connection string like jdbc:mysql://localhost:3306/yourdbname. Just choose driver and test connection with the same connection string.

Best regards, Max

Wed, 11/13/2013 - 08:27

Thanks Max. Your answer is very useful.