MySQL - What are user privileges in MySQL?

What are user privileges in MySQL? Explain some commonly used privileges in MySQL

Privileges 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.
MySQL - What are the scope levels a user privilege can be granted?
What are the scope levels a user privilege can be granted? - Global Level – This privilege applies to ALL databases present. Privileges granted at the global level stored in mysql.user table......
MySQL - Explain how to view and Revoke user privileges in MySQL
Explain how to view and Revoke user privileges in MySQL - Privileges assigned to users can be viewed using the SHOW GRANTS USER_NAME command......
MySQL - Explain the command line options offered by mysqld
Explain the command line options offered by mysqld - --help - Displays a short help message on how to use mysqld, --verbose --help - Displays a long help messages on how to use mysqld.....
Post your comment

Related Content

Follow us

▲