Delphi-MySQL最佳数据感知组件 [英] Delphi - MySQL Best Data aware components to use

问题描述

我需要我的应用程序连接到Web服务器的MySQL数据库，这是最佳选择。

I need my application to connect to my web server's MySQL database, what is the best option for this. Perfered Data aware Component.

我尝试了zeos 7，但是我一直收到错误消息：SQL错误：客户端不支持服务器请求的身份验证协议。考虑升级MySQL客户端，但无法修复它。

I tried zeos 7, but I keep getting the error: SQL error: Client does not support authentication protocol requested by server; consider upgrading MySQL client and have not been able to fix it.

谢谢

-Brad

推荐答案

@Brad ZEOS组件是连接到MySQL的绝佳选择，因为使用的是旧版的MySQL客户端，所以会出现此错误。 MySql 4.1引入了一种新的密码哈希算法，为解决此问题，您有2个选项。

@Brad the ZEOS components are an excellent alternative for connect to MySQL, you have that error because you are using an older version of MySQL client. MySql 4.1 introduces a new password hashing algorithm, for fix this issue you have 2 options.

1）更改MySQL客户端以使用4.1.1或更高版本的客户端库。

1) Change your MySQL client to use a 4.1.1 or newer client library.

2）使用OLD_PASSWORD函数

2) use the the OLD_PASSWORD function

您必须在mysql服务器中运行此脚本。

you must run this script in your mysql server.

SET PASSWORD FOR 'user' = OLD_PASSWORD('password');
FLUSH PRIVILEGES;

检查此链接以获取更多信息

check this link for more info

MySQL中的密码哈希

这篇关于Delphi-MySQL最佳数据感知组件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！