Not successful connection to MySQL (native data source configuration)
3 ビュー (過去 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.
zhuofei wu
2021 年 9 月 20 日
This vedio should be helpful. https://www.youtube.com/watch?v=XIgZlCdb-PA
1 件のコメント
参考
カテゴリ
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!