Database Reference
In-Depth Information
MySQL and Databases
1
About This Topic
There are many topics out there that describe MySQL and PHP. While most of them devote
a lot of space to describing PHP, they only briefly describe MySQL. I wanted to write a topic
that was different from this, in that I wanted a topic that described MySQL from a web per-
spective with only passing references to PHP. This is that topic.
This topic will describe the setup and use of a MySQL server and client and how to
access, use and secure this system.
MySQL and PHP originally appeared on the Linux platform, so many topics deal with it
from a Linux perspective. This topic will teach you about installing and using MySQL on
the Microsoft Windows platform. However, much of the theory behind the software will be
of use whatever platform you are using.
About MySQL
The MySQL website describes MySQL as the “world's most popular Open Source database.”
Its popularity is no doubt encouraged by the fact that if you need MySQL for non-commer-
cial use, you can download a copy free from the website.
MySQL is nearly always bundled with the PHP web scripting language, and the two
products are often seen mentioned together. Most Linux distributions come with MySQL
and PHP as standard and MySQL has been ported for use to a variety of different platforms.
Due to its bundling with PHP, MySQL is most often used as a database back end to a web-
server.
Who Can Use This Topic?
This topic should appeal to anyone who needs more insight into how databases work in
relation to the web. If you are completely new to using MySQL then this topic will serve as
a good introduction to the software. With an internet connection, you can easily obtain
MySQL and associated tools at no cost.
This topic will also be of benefit to someone wanting to learn SQL. While working
through the examples you will get a firm understanding of the concepts behind structured
query language and how you use it to communicate with databases.
1
