Not successful connection to MySQL (native data source configuration)
10 次查看(过去 30 天)
显示 更早的评论
Hi folks
I am trying to querry data from a native source SQL using Database Explorer as below:
The parameters are set properly (this is verified using a Python API before)
When I test this connection, it takes forever and no response received. Looks like connection is not successful.
Any input is much appreciated.
0 个评论
回答(3 个)
Kojiro Saito
2021-8-30
As written in this document, please make sure that you have installed MySQL Connector/C++ 8.0.15 driver.
---
MySQL Native Interface
You need to install the appropriate driver for your operating system. For the Windows® and macOS operating systems, use this link to download and install the driver. For Linux®, use this link.
---
Also, please make sure that you've added the path of driver libraries (by default in Windows, the path would be C:\Program Files\MySQL\Connector C++ 8.0\lib64).
setenv('PATH', [getenv('PATH') ';C:\Program Files\MySQL\Connector C++ 8.0\lib64']);
Or, add "C:\Program Files\MySQL\Connector C++ 8.0\lib64" to Windows System Path.
After that, I think you can avoid hang-up.
3 个评论
Kojiro Saito
2021-8-31
OK, so the connector setting looks good to me.
How about deleting preference directory?
prefdir
will return MATLAB's preference directory.
(ex, C:\Users\USENAME\AppData\Roaming\MathWorks\MATLAB\R2021a)
Deleting this preference directory and relaunching MATLAB might solve this issue.
If not, you had better re-install MATLAB.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!