Missing libmysql.dll

[perhen]

Hi
Today I was excited to find Lazarus. I had it installed right away. I got problems when I tried to connect to a MySQL database. I am using a MySQL50Connenction, server: localhost, database: test, proper username and password. But when I try to change Connect to true, I get the errormessage "Cannot load default MySQL library (libmysql.dll)". But that file exists several places.
Hoping for help.
Per

[marcov]

Today I was excited to find Lazarus. I had it installed right away. I got problems when I tried to connect to a MySQL database. I am using a MySQL50Connenction, server: localhost, database: test, proper username and password. But when I try to change Connect to true, I get the errormessage "Cannot load default MySQL library (libmysql.dll)". But that file exists several places.

Can be related to three problems:

(1) make sure that dll and your generated EXE are either both 32-bit or both 64-bit
(2) put the DLL in the application directory
(3) The same error might also happen  if that dll is found, but some other DLLs that libmysql.dll depends on are not. Copy _all_ dlls from the mysql-client distro to your app dir.

[exdatis]

Or put:
ControlPanel->System->EnvironmentVariable->Advanced->Path ->edit; path to mysql bin folder.

[perhen]

Hi
Thanks. I appreciate your comments. I copied the dll-file to the Lazarus dirctory, and I got the message "wrong version". I am running MySQL5.5 and TMySQL...50. Is there a TMySQL...55 component out there or should I go back to MySQL version 5.0?
Per

[BigChimp]

Might be a good idea to search the forum... IIRC, there is a MySQL 5.5 component in current trunk, but don't know when it was added.

[ferdinand]

I know the original post was three years ago but I have read it until now and I have the answer.
The Lazarus project's target CPU, the libmysql.dll and the MySQL Server, all must be of the same architecture, either 32 or 64 bits.
You find the libmysql.dll file in the MySQL Community Server and must copy it in the same folder of the project.

Cheers !!!