MySQL permission explanation

Rights and privileges

Privilege	Description
All	All privileges tGrant Option
Alter	UseALTER TABLE
Alter routine	UseAlter procedureAndDrop procedure
Create	UseCreate Table
Create routine	UseCreate procedure
Create temporary tables	UseCreate temporary table
Create user	UseCreate user,Drop user,Rename user, AndRevoke all privileges
Create View	UseCreate View
Delete	UseDelete
Drop	UseDrop table
Execute	UseCallAnd stored procedures
File	UseSelect into OUTFILEAndLoad data infile
Grant Option	UseGrantAndRevoke
Index	UseCreate IndexAndDrop Index
Insert	UseInsert
Lock tables	UseLock tables
Process	UseShow full processlist
Reload	UseFlush
Replication Client	Access to location of servers
Replication slave	Used by Replication slaves
Select	UseSelect
Show Databases	UseShow Databases
Show View	UseShow create View
Shutdown	UseMysqladmin Shutdown(Used to shut down MySQL)
Super	UseChange master,Kill,Logs,Purge master, AndSet global. Also AllowsMysqladmin debugLogin.
Update	UseUpdate
Usage	No access