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
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:
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 ]=