无法加载供应商库 libmysql.dll 或 libmysqld.dll

我想在 delphi xe10 中使用 MYSQL 和 fireDAC.所以，在表单上使用FDConnection，然后输入我的mysql db的基本信息.

但是当我尝试连接时，出现错误无法加载供应商库 libmysql.dll 或 libmysqld.dll"

我阅读了 embaradeco 手册，并已尝试过1. 将libMySQL.dll 复制到我的c:program files (x86)EmbarcaderoStudio\bin" : 失败(即无法加载db数据，仍然报错)2.在FDDrivers.ini中指定路径[MySQL] VendorLib=libmysql.dll :fail

所以，我很好奇我还需要检查什么.一定有什么我错过了.有人可以帮忙吗?

解决方案

我自己解决了这个问题.

我从这里得到提示http://chapmanworld.com/2015/01/18/连接-radstudio-to-mysql-with-firedac/

首先，我应该知道分别有 32 位 dll 和 64 位 dll.我使用了 64 位 dll 并得到了错误.所以，我使用 32bit dll我从 http://dev.mysql.com/downloads/mysql/ 获得了文件p>

复制到 Program Files(x86)/Embarcadero/Studio/17.0/bin然后我收到了成功消息.

此外，mariaDB 也可以正常工作.

**注意在链接中，作者不建议将文件复制到 .../bin 目录.但是我的情况，到现在为止我感觉很好.

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)EmbarcaderoStudio\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.

I got hint from here http://chapmanworld.com/2015/01/18/connecting-radstudio-to-mysql-with-firedac/

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.