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.
Operation Allowed by Privilege
Use temporary with create table
Use statements that read or write files on the server host
Explicitly lock tables with LOCK TABLES
View process (thread) activity
Use FLUSH and RESET
Ask server for information about replication hosts
Act as a replication slave
See all database names with SHOW DATABASES
Shut down the server
Miscellaneous administrative operations
I hope this will help you. Please feel free to give us your feedback in comments.