Re: viewing passwords as root

[Paul DuBois]

At 12:49 PM -0400 4/17/08, Pam Astor wrote:
>Hi,
>
>Is there a way to view mysql user passwords once logged in as the 
>MySQL root user in v 5.0.22?  Or are they encrypted even from the 
>MySQL toot user?

It's one-way encryption. You cannot see them.

http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_password
-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com