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.