Delphi FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]

Error : 
       Cannot load vendor library [libmysql.dll or libmysqld.dll]. THe system cannot find the file specified. Hint: check it is in the PATH or application EXE directories, and has x86 bitness.

Solution :

Do follow the below steps to solve this issue ,
  1. Download from: https://dev.mysql.com/downloads/connector/c/
  2. libmysql.dll copy to: C:\Program Files (x86)\Embarcadero\RAD Studio\12.0\bin

(OR)

Add the following lines into FDDrivers.ini

[MySQL]
BaseDriverID=MySQL
VendorLibWin32=c:\Windows\SysWOW64\libmysql.dll
VendorLibWin64=c:\wamp64\bin\mysql\mysql5.7.14\lib\libmysql.dll    

4 comments:

  1. Thank YOU!!!! the only solution that functions
    franz

    ReplyDelete
  2. Even with correct 32Bit libmysql.dll (it does not exist for 8.x so I used a 6.x copy) you cant connect as by default it used SSL (and 6.x does not support). So in mysql simply set user not to user SSL.

    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';

    ReplyDelete
  3. Hi, yes this paragraph is actually pleasant and I have learned lot of things from it on the topic of blogging. thanks.

    ReplyDelete
  4. Hello just wanted to give you a quick heads up. The words in your article seem to be running off the screen in Ie. I'm not sure if this is a format issue or something to do with browser compatibility but I figured I'd post to let you know. The layout look great though! Hope you get the problem resolved soon. Kudos

    ReplyDelete

Pages