Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 5.1 Reference Manual :: 5 MySQL Server Administration :: 5.4 The MySQL Access Privilege System :: 5.4.1 What the Privilege System Does
Section Navigation [Toggle]
- 5.4 The MySQL Access Privilege System
- 5.4.1 What the Privilege System Does
- 5.4.2 How the Privilege System Works
- 5.4.3 Privileges Provided by MySQL
- 5.4.4 Access Control, Stage 1: Connection Verification
- 5.4.5 Access Control, Stage 2: Request Verification
- 5.4.6 When Privilege Changes Take Effect
- 5.4.7 Causes of Access denied Errors
- 5.4.8 Password Hashing as of MySQL 4.1
The primary function of the MySQL privilege system is to
authenticate a user who connects from a given host and to
associate that user with privileges on a database such as
SELECT,
INSERT,
UPDATE, and
DELETE.
Additional functionality includes the ability to have anonymous
users and to grant privileges for MySQL-specific functions such as
LOAD DATA
INFILE and administrative operations.
© 1995-2008 MySQL AB, 2008 Sun Microsystems, Inc.
User Comments
Add your own comment.