MySQL Administration
One of the great
This tutorial is an
One of the most powerful
correctly administering the
characteristics of SQL
introductory guide to get
aspects of the MySQL server
MySQL server, including the
(Structured Query Language)
you started in the world of
is the amazing amount of
manipulation the privilege
is the fact that one can
server-side-scripting and
control the administrator
system, and making
develop access and modify
web databases. It covers
has over each user's
intelligent decisions about
data across various tables.
installation and
intended behavior. This
the capabilities
There are several benefits
configuration of MySQL,
control can restrict user
(permissions) given to users.
to this, including greater
Apache, and PHP. An example
privileges over a general
ease of manipulation,
script is also included as a
part of the server, such as
increased speed of access,
guide for making your own
limited access to an entire
and reduced data redundancy.
server-side-scripts. You
database, but can also be as
In MySQL (as well as many
will have accomplished after
specific as limiting
other SQL languages), this
successfully completing this
privileges for a specific
is accomplished via the join
guide: setup the MySQL
table or even column. This
command. This tutorial takes
database server, setup the
article will serve to
a look at several types of
Apache web server, setup the
explain the process in which
the join command including
PHP 3.0 Hypertext
the MySQL server
The Cross Join, The
Preprocessor for
grants/revokes these user
Equi-join, The Left Join,
server-side-scripting, and
privileges, highlighting in
and Self-joins.
create a simple web enabled
particular the newest
database.
additions to the MySQL
privilege system, the
tables_priv and columns_priv
tables. Please keep in mind
that the GRANT/REVOKE
commands detailed later in
this article are only
relevant to MySQL version
3.22.11 and up.
Date: Nov, 09 1999 Date: Nov, 09 1999 Date: Nov, 09 1999 Date: Nov, 09 1999 |