Matlab runs on Windows OS - mySQL database runs on Linux OS: what driver to use?

2 views (last 30 days)
As the title suggests: we have installed a mySQl database on a Linux/Ubuntu computer. I would like to connect to this database remotely using Matlab & the database toolbox. Matlab runs on a Windows 7 OS.
I'm a bit confused what driver to use: do I need to configure a JDBC driver or ODBC driver on my windows computer where Matlab is installed?
Probably a simple question for the expert, but a bit confusing to me ...
Thanks in advance!

Answers (1)

Arpan Badeka
Arpan Badeka on 31 Jul 2019
Edited: Arpan Badeka on 31 Jul 2019
Hi Henk-Jan,
  1. To connect remotely to the database server, you will have to update the "/etc/mysql/mysql.conf.d/mysqld.cnf" file to accept remote connections.
  2. Once setup is done. You can either configure ODBC connection by installing the driver on windows machine. Then use https://www.mathworks.com/help/database/ug/configureodbcdatasource.html to configure the datasource. Then using the database method(https://www.mathworks.com/help/database/ug/database.html?s_tid=doc_ta ) to connect to the datasource.
  3. Another Option is to download the JDBC database driver. Then use https://www.mathworks.com/help/database/ug/configurejdbcdatasource.html?s_tid=doc_ta to configure the datasource. Similarly, use database method to connect to the datasource.
Thanks,
Arpan Badeka

Products


Release

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by