title: Cannot connect Delphi App to mySQL database
body: <p>I have installed a local server Xampp, which is running mySQL database in Windows. I created a Database on it with one table. The thing is I cannot get a connection to the database when I use the dbExpress TSQLConnection component. When I set the properties as follows:</p>
  
  <pre><code>ConnectionName = MYSQLConnection
  Driver = MySQL
  Database = databaseName
  HostName = localhost
  password =
  UserName = root
  </code></pre>
  
  <p>When I change the connected property to true, I get the following error:</p>
  
  <pre><code>Borland.Data.TDBXError: DBX Error:  Driver could not be properly initialized.  Client library may be missing, not installed properly, of the wrong version, or the driver may be missing from the system path
  </code></pre>
  
  <p>I have tried making a connection to the database using the Data Explorer, but I still get the above error. I do not know what I'm missing or doing wrong.</p>
  
  <p>Im using Delphi-XE2. 
  with mySQL on the server: MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $.</p>
  
  <p>I have also tried using an ADO connection, but I do not know how to set the connection string. </p>
  
  <p>I'm still a noob and just want to learn how to make a connection to a mySQL database running on a web server. I cannot afford to buy any components.</p>