Skip to main content

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 .


 

Comments

Post a Comment

Popular posts from this blog

Step-by-Step guide for Installing MySQL on Windows

Step-by-Step guide for Installing MySQL on Windows Y ou can download the MySQL database from the MySQL website http://www.mysql.com by clicking on the downloads tab. Scroll down to the MySQL database server & standard clients section and select the latest production release of MySQL, 5.1.35 at the time of writing. Installation of MySQL Server: Unzip the setup file and execute the downloaded . MSI file. Follow the instructions below exactly when installing MySQL Server: Click on the "setup" MySQL Installing Type There are three type of MySQL Installation:- Typical  This MySQL installing process install the  MySQL server,command- line client and command line utilities. This command line and command client included in mysqldump, myisamchk and several tools to manage the MySQL Server. Complete By this installation type we install all the component included in the installation package. And this package include the component such as suppor...
Post a Comment
Read more

Exception Handling (RunTime Error)

Java Error Handling: In general, errors can be broken up into two categories: Design-time errors and Logical errors. Design-time errors are easy to spot because NetBeans usually underlines them. If the error will prevent the programme from running,   NetBeans will underline it in red. Logical errors are the ones that you make as a programmer. The programme will run but, because you did something wrong with the coding, there's a good chance the entire thing will crash. You'll see examples of run-time errors shortly. You'll also see how to handle them. But first a word on how Java handles errors. Exceptions What is an exception? An Exception can be anything which interrupts the normal flow of the program. When an exception occurs program processing gets terminated and doesn’t continue further. In such cases we get a system generated error message. The good thing about exceptions is that they can be handled. When an exception can occur? Exception can occur at run...
Post a Comment
Read more