GRANT AND REVOKE IN MYSQL

Hi.. Welcome to my blog at “We Are Knowledge”. This blog to fill many IT knowledge.. You can find it. In here to be found IT knowledge from desktop programming until web programming. So let’s do read my article, you can getting or taken FREE..

What do you find ?? About MYSQL ?? If yes.. you was choice the right blog.. because now, I want giving you tutorial about it, and discuss of “GRANT AND REVOKE IN MYSQL”. You know that ?? previously you was ever reading.. ?? If you never reading, so let’s do read my article… have fun and enjoy to read this article friends..

Is a tutorial on setting permissions in MYSQL programming language. And for a time, I would dispose of "REVOKE and GRANT" to set it.

      1. GRANT

Grant in program language MYSQL is Grant is an order that has been provided by the programming language MYSQL to give (make) the right of access permissions for the user (client) in order to access MySQL databases, tables and columns like (insert, update, delete). In addition to the functions at the behest of Grant can also add a new user with this command.

This is a common form using the GRANT command :

GRANT priv_type

ON {table_name | * | *.* | db_name. *}

TO user_name [IDENTIFIED BY ‘your_password’]

[WITH GRANT OPTION]

      2. REVOKE

REVOKE command in MYSQL programming language which is a command to delete or revoke the MySQL user permissions are previously been granted (using GRANT)

This is a common form using the REVOKE command :

REVOKE priv_type

ON {table_name | * | *.* | db_name. *}

FROM your_user_name

      3. OPTION OF PRIV_TYPE

You can choice one for change “prive_type” :

           

 

ALL PRIVILEGES	ALTER	CREATE
DELETE	DROP	FILE
DELETE	INSERT	PROCESS
REFERENCES	RELOAD	SELECT
SHUTDOWN	UPDATE	USAGE

 

Ok.. just it…
I hope you like this
See you later friends…