MySQL Manual
4 Database Administration
- 4.2 General Security Issues and the MySQL Access Privilege System
- 4.2.1 General Security Guidelines
- 4.2.2 How to Make MySQL Secure Against Crackers
- 4.2.3 Startup Options for
mysqldConcerning Security - 4.2.4 Security issues with
LOAD DATA LOCAL - 4.2.5 What the Privilege System Does
- 4.2.6 How the Privilege System Works
- 4.2.7 Privileges Provided by MySQL
- 4.2.8 Connecting to the MySQL Server
- 4.2.9 Access Control, Stage 1: Connection Verification
- 4.2.10 Access Control, Stage 2: Request Verification
- 4.2.11 Password Hashing in MySQL 4.1
- 4.2.13 Causes of
Access deniedErrors
4.2.5 What the Privilege System Does
The primary function of the MySQL privilege system is to
authenticate a user connecting 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 an anonymous user and
to grant privileges for MySQL-specific functions such as LOAD
DATA INFILE and administrative operations.
