When the project is in progress, use dbexpress to connect to MySQL. When testing data, connect to the MySQL 3.x version that comes with RedHat Linux9.0, and use the dbexpress version that comes with Delphi7 to connect to MySQL. No problem, however, when mysql4.2 is connected to Windows, the invalid user/password prompt appears, which was originally suspected to be libmysql. the dll version is 3. version X is not applicable. 4. in Version X, replace it with libmysql that comes with MySQL. DLL and Delphi prompt cannot find libmysql. DLL, suspected dbexpress dll: dbexpmysql. libmysql. only libmysql of the old version can be used. DLL. Find out the following solutions:
1. libmysql. dll is still in version 3.x and stored in the bin of the Delphi installation directory.ProgramDuring release, you must package it in the same directory of the program EXE or system directory.
2. Because mysql4.x and later versions change the password authentication method, 3. the password cannot be authenticated when the client of X is set and accessed. To solve this problem, use the old_password function to change the password of the database, for example:
Set password for 'user' @ 'host' = old_password ('newpassword ');