MySQL Access Privilege System
- MySQL has an advanced but non-standard security and privilege system.
- Its primary function is to authenticate users who connects from a given host and to associate that user with privileges on a database such as
SELECT, INSERT, UPDATE, and DELETE.
- It ensures that all users may perform only the operations allowed to them.
- Additional functionality includes the ability to have anonymous users and to grant privileges for MySQL-specific functions.
How does the privilege system work?
© 2007 John Michael Pierobon
Notes