Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
  • Privileges in MYSQl

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 786
    Comment on it

    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.

    Privilage  Operation Allowed by Privilege
    CREATE TEMPORARY Use temporary with create table
    CREATE USER Create,drop,rename accounts
    FILE Use statements that read or write files on the server host
    LOCK TABLES Explicitly lock tables with LOCK TABLES
    PROCESS View process (thread) activity
    REPLICATION CLIENT Ask server for information about replication hosts
    REPLICATION SLAVE Act as a replication slave
    SHOW DATABASES See all database names with SHOW DATABASES
    SHUTDOWN Shut down the server
    SUPER Miscellaneous administrative operations

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


 0 Comment(s)

Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: