MySQL Library Error

[IndianaJones]

Hi all,

I have installed SQLdb package, when I make a connection I get this error.

Can not load default MySQL library ("libmysql.dll" or "libmysql.dll"). Check your installation.

Any help would be appreciated.
Thanks

[bobo]

That DLL has nothing to do with Lazarus or Freepascal.

You need to download it from mysql.com so Lazarus/Freepascal can access MySQL databases.

1. Go to http://dev.mysql.com/downloads/mysql/5.0.html#win32

2. Click on Pick a mirror for the "Without installer" version (win32 or win64 section) whichever Windows you have

3. Click on "No thanks, just take me to the downloads!"

4. Download the .zip file from your closest location

5. Unzip it

6. Copy the libmysql.dll from the /bin directory of the unzipped files to your \windows\system32 directory

7. Delete the unzipped files and the downloaded .zip file itself

8. Done.

[skaner1900]

but which version I need?
http://dev.mysql.com/downloads/mysql/
here are two files with same names and else sizes...
which is correct?
(x86, 32bit)

[skaner1900]

hmmm there aren't libmysql.dll... :/

[Leledumbo]

but which version I need?
http://dev.mysql.com/downloads/mysql/
here are two files with same names and else sizes...
which is correct?

You need the client library. Just download any of the package on that page (according to your platform of course), the MSI and ZIP version is actually the same, both have server and client libraries. I suggest taking the smaller ZIP.

[skaner1900]

so... i did it... and... in all zips aren't any libraries, only in msi installer i found libmysql.dll but in version 5.5.18...

[Leledumbo]

Looks like I've found a dedicated connector download page:
http://dev.mysql.com/downloads/connector/c/

[skaner1900]

Yeah... here is only 6.0.0, but I need 5.0 :/
or newest component