- 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.
- 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.
- 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.
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!
Arpan Badeka on 31 Jul 2019
Edited: Arpan Badeka on 31 Jul 2019