Hello Readers,

Hope you are doing good today.

Today on My blog, I am going to explain about the Administrative Privileges in MYSQL.

What is Privileges

Several types of privileges can be granted to an account. Privileges should be granted according to how the account is to be used. Some example.

• An Account that needs only read access to a database can be given only the SELECT Privilege
• An Account that needs to modify data can be given the DELETE, INSERT, and UPDTAE Privilage
• Administrative accounts can be given the PROCESS or SUPER privilege for viewing client process activity or killing connections,or the SHOUTDOWN privilege for stopping the server

The MySQL Server bases access control on the contents of the grant tables in mysql database. These tables define MYSQL Account and privileges they hold. To Manage their contents, use statement such as CREATE USER, GRANT, REVOKE. These statements provide an interface to the grant tables that enables the specification of account-management operation without having to determine how to modify the tables directly. The MYSQL Determine what changes to the grant tables are needed and makes the modifications necessary.

Types of privileges that MYSQL Supports. Several types of privileges can be granted to a MYSQL Account, privileges can be granted at different levels (globally or just fro particular database, tables or columns). For example, a user can be allowed to select from any tables in any database by granting the select privilege at the global level.

The  Administrative Privileges that MYSQL supports are shown in the following tables.

I hope this will help you. Please feel free to give us your feedback in comments.