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.