Grant privileges

Hi,

I have doubt regarding granting privileges. I have created 'test' user from 'root' user and granted all permission for test.

1) Now if i log into test user is it possible for me to revoke or grant permission for test user itself.
2) Is it possible to grant or revoke permission for other users from test user.

when i tried from test user i got the following error message:
Access denied for user 'test'@'localhost' (using password 'YEs').

but when i tried from root user it worked.

3) is it only the root user can grant or revoke permission for other users?

4)What encryption technique is used by mysql for password while creating new user.

Thanks
Thanuja.

If I remember my many fights with sql... the answer are

Only the root user can do any granting or revoking of permission. If I remember correctly it is because the early unix systems were established as multilple user systems and there needed to be away to handle access etc... the root user.
The root user has what would be considered administrative powers like add , revoke, allow...

I think this is correct, but if I am wrong someone please correct it. It has been a few years since I played with sql and phpadmin

There's a grant_priv column in the user table in the mysql database which controls whether or not a user can grank and revoke. By default, the root user of the mysql database is allowed grant_priv. However, and new users created via grant commands are not - even if given grant all.

If you (as the roor user) want a user to be able to grank and revoke, you much run a grant / revoke on his / her account with grant option - yes, that extra text - added on the end.

hi sannbe and grahame. thanks for ur reply. well i understood now and got clear idea.

What encryption technique is used by mysql for password while creating new user?

while creating new user i user password('new password'). what encryption it does.

Moreover ive been using mysql for past 8 months. Iam interested in doing MySQL developer certification. can u guide me as how to proceed?

Thanks and Regards,
Thanuja.

http://www.mysql.com/certification/50/

Will give u information on certification. I am self taught so I learned by mistakes and am still learning. hope this helps

Hi thanks for ur info.I will enquire more about the certification in the test centers. Do anyone have MySQL Dump. If so please can u send it.

Thanks,
Thanuja.

1. Yes

2. No need - Mysqldump is a part of the standard mysql download. Start at http://dev.mysql.com/ and navigate from there for the release number and operaing system you need it for.