|
Htprotect allows you to
This is a small console
This excellent five-page
This article will aid the
manage user accounts for the
program written in perl,
tutorial introduces you to
reader in learning the basic
htaccess capabilites of the
which allows you to manage
the world of PHP3
operations of the
apache webserver from a
notes similar to programs
programming and Web database
MySQL server,
webinterface. It uses a
like "knotes" from
interfacing with
including how to make a
MySQL database for
commandline. You can add,
MySQL. Main topics
proper connection, set up
storing user data.
edit, list and delete as
include: The definition of
the server for consequential
many notes as you want. The
PHP, How to use HTML forms
manipulation and execute
notes are stored in a
and variables with PHP,
basic commands. The commands
MySQL database.
MySQL database
covered within this article
interfacing, Outputting data
are among the most important
from MySQL, and more.
commands within the
language, as they form the
basis for the more advanced
commands.
Date: Nov, 09 1999 Date: Nov, 09 1999 Date: Nov, 09 1999 Date: Nov, 09 1999 |
|
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
MySQL server,
(Structured Query Language)
you started in the world of
server is the amazing amount
including the manipulation
is the fact that one can
server-side-scripting and
of control the administrator
the privilege system, and
develop access and modify
web databases. It covers
has over each user's
making intelligent decisions
data across various tables.
installation and
intended behavior. This
about the capabilities
There are several benefits
configuration of
control can restrict user
(permissions) given to users.
to this, including greater
MySQL, Apache, and
privileges over a general
ease of manipulation,
PHP. An example script is
part of the server, such as
increased speed of access,
also included as a guide for
limited access to an entire
and reduced data redundancy.
making your own
database, but can also be as
In MySQL (as well as
server-side-scripts. You
specific as limiting
many other SQL languages),
will have accomplished after
privileges for a specific
this is accomplished via the
successfully completing this
table or even column. This
join command. This tutorial
guide: setup the
article will serve to
takes a look at several
MySQL database
explain the process in which
types of the join command
server, setup the Apache web
the MySQL server
including The Cross Join,
server, setup the PHP 3.0
grants/revokes these user
The Equi-join, The Left
Hypertext Preprocessor for
privileges, highlighting in
Join, and Self-joins.
server-side-scripting, and
particular the newest
create a simple web enabled
additions to the
database.
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 |