c 连接mysql dll无法读取,无法加载供应商库libmysql.dll或libmysqld.dll

I want to use MYSQL in delphi xe10 with fireDAC.

So, FDConnection on the form, then input basic information about my mysql db.

But when I try to connect, there is an error

"cannot load vendor library libmysql.dll or libmysqld.dll"

I read embaradeco manual and I have been tried

1. copy libMySQL.dll to my “c:\program files (x86)\Embarcadero\Studio\\bin” : fail(That means cannot load db data, still got error)

2. specify path in FDDrivers.ini

[MySQL] VendorLib=\libmysql.dll :fail

So, I'm curious what else I have to check. There must be something I missed.

Anyone can help?

解决方案

I solved this problem myself.

First, I should know there are 32bit dll and 64bit dll separately.

I used 64bit dll and got error. So, I use 32bit dll

I got files from http://dev.mysql.com/downloads/mysql/

Copy it to Program Files(x86)/Embarcadero/Studio/17.0/bin

then I got success message.

Additionally, mariaDB also works fine.

**CAUTION

In the link, Author doesn't recommend copy file to .../bin directory. But My case, I feel fine till now.