Data Analysis System DIY3/3: Local 64-bit Win7+matlab 2012b access VMware centos7+mariadb

Data analysis System DIY in the three tasks to complete.

First, with VMware 64-bit CentOS, database service end with CentOS bring the good.

Second, data acquisition and pretreatment with dev-c++ programming solution.

Third, using the local Win7 64 matlab r2012b Connection database for mining analysis.

This article is the process of completing a third task.

1. First download the MARIADB database JDBC driver package in jar format,

2. Copy the downloaded driver to the "MATLAB installation directory \java\jar"

3. Edit "matlab installation directory \toolbox\local\classpath.txt"

Add "$matlabroot/java/jar/mariadb-java-client-1.1.7.jar" at the end of the file

4. Open Matlab, and if you have previously opened MATLAB, you should restart it at this time.

5. Run the command "Dexplore" in MATLAB, the effect

3. Click New to create a new JDBC database connection

4. Set the data source with the following parameters

Data: Source name:mariadb//Can be arbitrary

Vendor: Other

Driver: Org.mariadb.jdbc.Driver

URL: jdbc:mysql://192.168.124.128:3306/test

Note: The middle IP address and port are the database server address and the MARIADB port, and the end is the database to open

Username: root

Password: Root's password

Effect

5. Click "Test" button to show success!

6. Click ' Save ' to save the settings

7. Create a connection as shown

8. Success!

Task Three, Mission accomplished!

Data Analysis System DIY3/3: Local 64-bit Win7+matlab 2012b access VMware centos7+mariadb