Access MySQL using dbexpress component in Delphi2009 (Landing page)

First, create a new data access module, the following figure:

This uses the MySQL database, taking into account the Dbgo component (ie ado) unfriendly to MySQL, using the Dbexpress component's access to the travel database.

First, add a tsqlconnection control.

In order to access the database using dbexpress, you need to copy the LibmySQL.dll files under the bin directory under the MySQL installation path to the Bin directory of the Delphi installation path.

As shown above, make the necessary settings. (The Loginprompt property is set to False to close the authentication dialog box each time the database is connected)

Create a form to use as a landing page, as shown in the following illustration: