MySQL - What are user privileges in MySQL?
What are user privileges in MySQL? Explain some commonly used privileges in MySQLPrivileges in MySQL are used to restrict users accessing data objects and functions. Below are the commonly used:-
ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands. ALTER - Allows the user to use ALTER TABLE commands. DROP - Allows the user to use DROP TABLE commands. DELETE - Allows the user to use DELETE commands. INSERT - Allows the user to use INSERT commands. UPDATE - Allows the user to use UPDATE commands. SELECT - Allows the user to use SELECT commands. SHUTDOWN - Allows the user to use "mysqladmin shutdown". INDEX - Allows the user to create and drop indexes. CREATE USER - Allows the user to manage user accounts. CREATE VIEW - Allows the user to user "CREATE VIEW" commands. USAGE - No privileges.
|