How to find the password of a non-root MySQL user?

You can't recover the passwords as they are stored in an encrypted format but you can reset them

serverfault.com/a/230121