Delphi 10.3 FIREDAC连接到mysql 8 [英] Delphi 10.3 FIREDAC connect to mysql 8

问题描述

我在Win32目标平台和win64上测试了

Win10是64位，MySQL 8 64位

I have tested on Win32 target platform and win64
The Win10 is 64 bit and MySQL 8 64bit

FDConnection
FDPhysMySQLDriverLink

VedorLib
C:\Program Files\MySQL\MySQL Server 8.0\lib\libmysql.dll


[FIREDAC][Phys][MySQL] autentication PlugIn caching_sha2_password: cannot be loaded vendor library

Library has unsupported architetture[x64]. required[x86]

我尝试过：



drivername MySQL

端口3306

服务器127.0.0.1



同样的问题



服务器db4fre.net

What I have tried:

drivername MySQL
port 3306
Server 127.0.0.1

same problem for

server db4fre.net

推荐答案

错误信息不言自明......

The error message is self-explanatory...

引用：

库不支持architetture [x64]。 required [x86]

Library has unsupported architetture[x64]. required[x86]

如此处所述： Delphi 10.3中的MySQL配置 - Delphi语言 - 编程语言 - IDERA社区 [ ^ ] ...

As is stated here: Mysql configuration in Delphi 10.3 - Delphi Language - Programming Languages - IDERA Community[^]...

Quote：

如果您使用64位SQL服务器，客户端DLL也将是64位。要在设计时连接或将此服务器与32位应用程序一起使用，请从 MySQL下载32位DLL： ：下载Connector / C（libmysqlclient） [ ^ ]。

If you use a 64-bit SQL server, the client DLLs will also be 64-bit. To connect at design time or to use this server with a 32-bit application, download 32-bit DLLs from MySQL :: Download Connector/C (libmysqlclient)[^] .

这篇关于Delphi 10.3 FIREDAC连接到mysql 8的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！