MySQL - What the Privilege System Does
By Manju S Reddy
MySQL - What the Privilege System Does???
Teacher SiliconIndia replied to Manju S Reddy Friday, March 19, 2010
Hi Manjunath,
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.