Mysql password

how can I retrieve a password for a mysql user?

thanks.

The only way I found was to create a new user for the database, and change the relevant scripts.