Search code examples
mysqlconnectionweka

WEKA & MySQL Setup a connection

WEKA Explorer can't open a connection to MySQL.

connecting to: jdbc:mysql://MYSERVER:3306/NAME = true

by the way: mysql driver was downloaded mysql-connector-java-5.1.14-bin & classpath was set.

(User & Pass are ok because it works with MySQL Workbench)

when clicking on the JButton OK (in the form 'Open DB'), then a message box shows an error - see image:

Error Message

(screen shot shows infamous "no driver" error)

weka version is 3.6.3.

any suggestions ?

Solution

  • Wasted half an hour on this same problem, here's the answer:

    Download the connector from http://dev.mysql.com/downloads/connector/j/

    Extract the JAR file.

    Edit C:\Program Files\Weka-3-6\RunWeka.ini

    Change last line to:

    cp=%CLASSPATH%;c:/mysql-connector-java-5.1.16-bin.jar

    You may of course save your mysql-connector jar to a different path, but mind the forward slash, nevermind being on Windows.