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

1 次查看（过去 30 天）
Henk-Jan Ramaker
Henk-Jan Ramaker 2019-7-30
编辑： Arpan Badeka 2019-7-31
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!

请先登录，再回答此问题。

回答（1 个）

Arpan Badeka
Arpan Badeka 2019-7-31
编辑：Arpan Badeka 2019-7-31
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

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by