
This blog post, I will show you how to setup mysql with JDBC drivers in matlab
Step-1: Add JDBC driver to the MATLAB java classpath using javaaddpath
First of all, download mysql-jdbc jar file and save it in some desired location, I am on ubuntu and I saved it under /usr/local/
. I use javaaddpath
command to add the driver to the classpath. NOTE: Execute the below command on MATLAB
javaaddpath /usr/local/mysql.jdbc_5.1.5.jar
Step-2: [Optional] Add JDBC driver to the MATLAB java classpath using javaclasspath.txt
Create a file with name javaclasspath.txt
under preferences folder, to check the preferences directory, execute below command on MATLAB
prefdir
In my case, below is my preferences folder, so I will use this path to create javaclasspath.txt
and update the path
/root/.matlab/R2018b
Since I am on ubuntu, I will use the below command to update the static path, you can use any of the editors for updating the same depending on the operating system you use.
echo "/usr/local/mysql.jdbc_5.1.5.jar" > /root/.matlab/R2018b/javaclasspath.txt
Step-3: Restart the PC
Sometimes, We realize this lately, I was wasting time on trying to fix the JDBC error without restarting the computer.

Step-4: Configure MYSQL
Finally, let’s set this up, Open database explorer from APPS
tab and click on configure data source
, then name your database and test the connection as shown below. Once the connection is successful, save and close the window.

Note: I made my configuration on the following system profiles,
- OS: ubuntu 18
- Matlab 2018b
- Mysql Ver 14.14 Distrib 5.7.25
- Openjdk 1.8.0_191
- mysql-connector-java-8.0.15.jar