Chapter 2: What is MySQL?

Chapter 2 - What is MySQL?
byGareth Downes-Powellet al.
Wrox Press 2003

Overview

Author: Bruno Mairlot

• Overview of MySQL

• Installing and configuring MySQL

• SQL and database primer

This book is about PHP development with Dreamweaver MX, and the only Database server support that Dreamweaver MX currently provides for the PHP language is MySQL.

This chapter will introduce you to the world of MySQL, independently of PHP and Dreamweaver. We will look at what MySQL is, how to install it, and how to administer it.

We will also give you an overview of getting started with SQL, the language used to communicate with MySQL. We will review the concept of databases and tables, how to create and delete them, as well as getting to know the structure of existing tables.

We will look at how to configure the MySQL server by creating accounts and setting up the permission system.

Finally, we will introduce you to two tools that will let you administer and issue SQL queries with a nice User Interface.