Using Delphi with MySQL - Required Tools

(Page 2 of 5 )

Here is the list of tools you will need:

• MySQL Database Server
  
•  MySQL Connector/ODBC  3.51
  
•  MyCC(optional)

You can download ODBC Connector from http://dev.mysql.com/get/Downloads/MyODBC3/mysql-connector-odbc-3.51.12-
win32.zip/from/pick. Pick a mirror from which to download the package. Unzip and run the executable.

Then download the MySQL Server from the downloads page of the MySQL site located at http://www.mysql.org/.

Next download the MySQL Control Center (MyCC) application from http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/downloads/mysqlcc.html

MyCC is basically a database management program that enables you to create, delete, view and update databases that is served by MySQL. Please note that you do not have to download this program; in fact, you do not have to download any MySQL database admin applications at all. You could simply use the command line interface of the server to create and administer your databases. But you will need to know a bit of SQL in order to use the command line interface. I suggest that you download a MYSQL database management program if you do not want to learn SQL.

To summarize, there are three things we need to do to use MySQL Server with our Delphi application:

1. Download and install MySQL Server from http://www.mysql.org.
   
2. Download  and install MySQL ODBC Connector.
   
3. Download and install MyCC (optional but recommended).

Once you have all of them installed, we then need to create the database. Our application is going to have a database called publish and a table called articles. It will handle the submission, editing and deleting of articles.

Next: Setting up the Connector >>
 

More Delphi-Kylix Articles
More By Leidago

Comments On: Using Delphi with MySQL

· MYSQL is a very powerful and easy to use database server that is freely available...   >>> Post your comment now!