PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies

Book V

MySQL

MySQL Account Privileges

Privilege	Description
ALL	All privileges
ALTER	Can alter the structure of tables
CREATE	Can create new databases or tables
DELETE	Can delete rows in tables
DROP	Can drop databases or tables
FILE	Can read and write files on the server
GRANT	Can change the privileges on a MySQL account
INSERT	Can insert new rows into tables
SELECT	Can read data from tables
SHUTDOWN	Can shut down the MySQL server
UPDATE	Can change data in a table
USAGE	No privileges

For more info on MySQL, go to www.dummies.com/extras/phpmysqljavascripthtml5aio.

Contents at a Glance

Chapter 1: Introducing MySQL

Examining How MySQL Works

Understanding Database Structure

Communicating with MySQL

Protecting Your MySQL Databases

Chapter 2: Administering MySQL

Understanding the Administrator Responsibilities

Default Access to Your Data

Controlling Access to Your Data

Setting Up MySQL Accounts

Backing Up Your Database

Restoring Your Data

Upgrading MySQL

Chapter 3: Designing and Building a Database

Designing a Database

Designing a Sample Database

Writing Down Your Design

Building a Database

Changing the Database Structure

Chapter 4: Using the Database

Adding Information to a Database

Looking at the Data in a Database

Retrieving Information from a Database

Updating Information in a Database

Removing Information ...