how can we get the password of the current logged in user in mysql

[phpprogrammer]

hi,

is there any query to get the password of the user when he logged in.

or

any mysql logged in user can get his password through any sql query

regards,
bvsureshbabu

[Sxooter]

Nope. They're stored as md5 hashes, and I don't think the session stores them but rather the md5 hash internally. Just guessing, but I know there's no SQL method for pulling this information up. It would be a security hole / bug if there was a way.