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 |
Contents at a Glance
Understanding Database Structure
Protecting Your MySQL Databases
Chapter 2: Administering MySQL
Understanding the Administrator Responsibilities
Controlling Access to Your Data
Chapter 3: Designing and Building a Database
Changing the Database Structure
Adding Information to a Database
Looking at the Data in a Database
Retrieving Information from a Database