Businesses that are strapped for money but need an RDBMS know that MySQL fits the bill. It works well with many programming languages, but what do you do if you need to write a multi-user database application for it in a language that it doesn't support quite as well? That's the challenge our author faced as a Delphi programmer. To see how he tackled it, keep reading.
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:
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.