Update client dlls [closed]

Question

Update client dlls [closed]

Navigation

#1 by (0 votes)
#2 by (0 votes)

6

I have software that communicates with a MySQL 4.1.14 database.

I installed a new server for Mysql 5.6 tests, but when I communicate with the new database, the message that the client does not support the authentication protocol requested by the server appears. Consider upgrading the client.

This software is just an .exe with three dlls in the same executable folder:

libmysql.dll
libpq.dll
libpq721.dll

To update the client, do I just need these new dlls? If so, how to find the correct ones, then I tried to download some, but it only got worse.

The software is done in Delphi and I have the source, do I need to change something in this source to update the client?

mysql delphi

asked by anonymous 21.05.2015 / 18:17

2 answers

Bootstrap v2.3.2 grid does not work in IE9 [closed] Project import encoding problem for Android Studio

score 0 · Answer 1

Note that libpq is for PostGree access and should not be required to access MySQL.

Since you've only tried to copy the new DLLs and it did not work, your current EXE can not access the new DLLs, or they are not the correct ones.

Considering the previous paragraph and that the new DLLs are correct, in the simplest case, just update libmysql.

If it does not work, in the next case, still simple, you only need to compile your program with the new libraries, so that the linker makes the correct links. If the program compiles without errors, it will most likely work, otherwise you may need some code changes.

I do not remember well, but I think the MySQL 5 server can be configured to accept the same security as version 4, which may be another alternative if client update is not possible.

Edition 2015-05-22: The protocol, must be specified in the ZeosDBO component, and is different for version 4 and 5 of Mysql. For version 5, try using <componente>.Protocol = 'mysqld-5' . If there is connectionString, it is not the same protocol as it is from the same component, checkbox.

If ZeosDBO does not have this option, check for the component update ( link ). However, you may have to check to see if it is still compatible with the code.

score 0 · Answer 2

If the database is MySql, you only need libmysql.dll. To have compatibility you would have to do a downgrade by installing MySql Server 4 on your machine, after that look for the dll libmysql.dll in the installation folder of it and put in the place that you have today. The configuration of the ZConnection component informing the correct version of MySql is also important.