Introduction

For many, the task of creating and manipulating MySQL databases is a daunting task. It is often difficult to master the complex commands required by the MySQL console and MySQL Admin. Luckily there is hope. With the increasing popularity of MySQL, many 3rd party tools have been developed to ease its use. In fact, there are numerous graphical MySQL clients from which to choose. It is mostly a matter of your personal preference as to which graphical client you choose to implement. A good place to look for many of these graphical clients is on the MySQL website under contributed software.

The advent of these graphical front-ends has made working with MySQL almost as easy as working with many of the popular desktop database programs, only far more powerful. Imagine harnessing the power of a multi-threaded database application on your personal computer. MySQL and almost any graphical client can even be used on your desktop as a viable and powerful replacement for Microsoft Access.

In this article, we will take a look at the basics of connecting to and using one of the most popular of these MySQL graphical interfaces, MySQL Front. More specifically we will learn how to:

connect to the MySQL server
create databases
add tables and fields
add and manipulate data
and run SQL statements
This tutorial requires that you have already obtained and installed MySQL (http://www.mysql.com), and MySQL Front (http://www.mysqlfront.de).

Read More...