Not successful connection to MySQL (native data source configuration)
18 views (last 30 days)
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.
Kojiro Saito on 30 Aug 2021
As written in this document, please make sure that you have installed MySQL Connector/C++ 8.0.15 driver.
The native driver installer is linked from here.
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.