Entry

How do I find out the username and password of a database?

Feb 22nd, 2008 20:24
dman, Jason Ross, Douglas Tan, http://sturly.com

\u mysql
SELECT User, Password FROM User;
If the password is stored in an encrypted format, you will be unable to 
retrieve it. In that case you will need to reset it:
\u mysql
UPDATE User SET Password = password("newPass") WHERE User = userName;
NOTE: instead of using the password function, you may also use the md5 
function, which provides a better encryption routine.
=[ jason ]=