Weka accessing MySQL database

When you use Experimenter in Weka to connect to the Mysql database, the default link is jdbc: idbexperiments:

When you use Experimenter in Weka to connect to the Mysql database, the default link is jdbc: idb = experiments:

When you use Experimenter in Weka to connect to the Mysql database, the default link is:

Jdbc: idb = experiments. GP

Change it:

Jdbc: mysql: // 222.35.250.58: 3306/labin_ultimate_original

(Mysql host and database names need to be set according to the actual situation)

An error still occurs:

Exception: java. SQL. SQLException: No suitable driver found for jdbc: mysql...

This is because Weka does not find the JDBC driver.

Even from

Download the JDBC driver and install it (set CLASSPATH to the specified bin. jar file.

View the source code of DatabaseUtils. prop. The configuration is as follows:

# The comma-separated list of jdbc drivers to use

# JdbcDriver = RmiJdbc. jdbc driver, jdbc. idbDriver

# JdbcDriver = jdbc. idbDriver

JdbcDriver = RmiJdbc. connector Driver, jdbc. idbDriver, org. gjt. mm. mysql. Driver, com. mckoi. JDBCDriver, org. hsqldb. jdbcDriver

# JdbcDriver = org. gjt. mm. mysql. Driver

# The url to the experiment database

# JdbcURL = jdbc: rmi: // expserver/jdbc: idb = experiments. GP

JdbcURL = jdbc: idb = experiments. GP

# JdbcURL = jdbc: mysql: // mysqlserver/username

Now we can see the cause: Weka only sets org. gjt. mm. mysql. Driver as the JDBC Driver, and does not set com. mysql. jdbc. Driver!

Download the Driver of org. git. mm. mysql. Driver and install it.

Or change the jdbcDriver configuration under the experiment directory:

JdbcDriver = RmiJdbc. jdbc Driver, jdbc. idbDriver, org. gjt. mm. mysql. Driver, com. mckoi. JDBCDriver, org. hsqldb. jdbcDriver, com. mysql. jdbc. Driver

(Added the com. mysql. jdbc. Driver)

In fact, it is inconvenient to use the default Weka settings. It is best to modify all the configurations to the configuration that matches your needs and then package them for running.