DBX Error: Driver could not be properly initialised

Question

I am running Delphi XE3 (Ultimate Edition), MySQL database and this is the error I get when a click Test Connection.

As a response, I located the libmysql library in my xampp directory and copied it over to my System32 directory. This does not work however.

Which libraries/drivers is this message referring to and what is the correct directory to place them in?

libmysql version - 5.5.16.0

Callow

Are you using a 64 bits Windows? if that is the case you must copy the libmysql file to the C:\Windows\SysWOW64 folder. – Dislocation

Answer 1

The message states that the library could be:

• missing;
• not properly installed; or
• of the wrong version

I googled for the library and came across this blog post which discusses that aforementioned error message and provides a more recent version of the libmysql library which is to be placed in the bin directory (Embarcadero\RAD Studio\10.0\bin).

libmysql Library Download Link

Callow

Answer 2

You should never place any 3rd party files in the bin directory - XE3 does not allow this Please Read this document

Brilliance