How to properly install the libmysql.dll on Windows?

Question

I'm getting the following error message when I try to run an application that connects to a MySQL database instance:

"[FireDAC][Phys][MySQL]-314. Cannot load vendor library [libmysql.dll or libmysqld.dll]. Hint check it is in the PATH or application EXE directories, and has x86 bitness.".

The error persists even with the libmysql.dll file on the same directory of the application executable.

Answer 1

Beyond to install the MySQL Connector/C to get the libmysql.dll, it is necessary to install the Visual C++ Redistributable Packages for Visual Studio 2013 too.

Answer 2

Just copy libmysql.dll into the same folder of the application, or add the path to libmysql.dll into Path variable of system.