How to Grant Privilages to an account in MYSQL

MYSQL 'GRANT' statement allows you to grant access privileges to database account.

To achieve same ,syntax  is as follow:

Syntax:-

GRANT privileges [Column_List]
ON  [Object_Type]
Privilege_level
To account [IDENTIFIED BY 'password']
[REQUIRE encryption]
WITH with_option ;

Detailed explanation:

Privileges:- It indicates that you have assign privileges to account.

column_List :- (1) Its  optional.
                         (2) Column(s) to which privileges apply.

Privileges_level :- Level at which privileges apply.

You can use global  privileges,database privileges,table specific privileges, column privileges etc.

Account :- Which  account is being granted privileges.

Password:- Specifies password.It replace old password.

Required:- Clause specify whether the account has to connect to database server over secure connection SSL.

* If you want the account to have privilege that can grant its own privileges to over other account ,you need to use WITH clause with the grant OPTION clause.

Examples:

(a) If you want to create super account that can do anythings
   
    CREATE USER 'super'@'localhost' IDENTIFIED BY 'super123' ;

  GRANT ALL ON *.* TO 'super'@'localhost'  WITH GRANT OPTION ;

Note :-*.* clause  means all database and all object in database.

(b) GRANT select,update,delete ON classic.* TO 'testuser'@' %' ;

  Here classic is database name &  testuser is user name. % mean access from all .