ADD, DELETE, REPLACE ACCESS RIGHTS IN MYSQL

Hello my friends.. you are on my blog at “We Are Knowledge”…  In here you will getting and take many IT knowledge likely : Mysql, Php, Cobol, Visual Basic 6, and other Program language..

Likely this article to fill IT knowledge, because now, I want giving you tutorial program language MYSQL again, but with different material.. And this is the tutorial :

1. Add and manage user access rights

2. Removing User Access Rightsc and

3. Changing the User Password

You will know all ? let’s do read this article… have fun friend to read my article…

1. Add and manage user access rights

We can also add and set permissions contained in MYSQL programming language .. To add we usually do the command "insert" in the database we have created. Or we can also use the command "grant" and "revoke".

These are a few examples to add permissions :

Example 1 :

GRANT USAGE ON  *.* TO wak@localhost

IDENTIFIED BY ‘knowledge’;

Example 2 :

GRANT ALL PRIVILEGES ON havefun.* TO wak@localhost

IDENTIFIED BY ‘knowledge’ WITH GRANT OPTION;

Example 3 :

GRANT ALL PRIVILEGES ON *.* TO wak@localhost

IDENTIFIED BY ‘knowledge’ WITH GRANT OPTION;

These are a few examples to set permissions :

Example 4 :

GRANT CREATE ON weare.* TO knowledge;

FLUSH PRIVILAGES;

Example 5 :

GRANT ALL PROVILAGES ON weare.* TO knowledge;

FLUSH PRIVILAGES;

2. Removing User Access Rightsc

We can also remove user permissions on the database we have created at MYSQL. we can use the command "REVOKE" to delete user permissions on the database.

These are a few examples to remove permissions :

Example 6 :

REVOKE CREATE ON weare.* FROM knowledge;

FLUSH PROVOLAGES;

3. Changing the User Password

And now we have entered the final discussion, the change password that we created earlier. We can make use of the "update". Since the "update" is the command to change the data that we created earlier in MYSQL, without having to remove up first.

Example 7 :

UPDATE weare SET password = PASSWORD(‘3626’) WHERE

User = ‘admin’ AND host = ‘localhost’;

Example 8 :

SET PASSWORD FOR admin@localhost = “ PASSWORD (‘3226’);

FLUSH PRIVILEGES;

Ok just for it..

I hope you understand..

See you laters..