Delphi 7 How to connect MySQL 5.5.15

System environment: Windows XP SP3

Software Environment: Delphi 7, mysql-installer-5.5.15.0

1.ODBC mode

MySQL must first have the ODBC driver, I downloaded the full installed version, including MySQL server, a variety of supported connections, workstations, sample databases, documents, if not ODBC-driven, you can go to the official website http://dev.mysql.com/downloads/ connector/odbc/download.

① Data Source Method

First, verify that the MySQL ODBC driver is installed, open the control Panel → administrative tools → data source, switch to the driver page, and view the MySQL ODBC 5.1 Driver, as shown in the following illustration:

Switch to system DSN → add → MySql ODBC 5.1 Driver, as shown in the following illustration:

The MySQL data source configuration pops up, the data source name is random, TCP/IP server is the database address, user username, password password, database connected databases, point "test" to test the connection, the following picture shows: