Entry

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

Jul 1st, 2009 23:55
khalid khalid, dman, Jason Ross, Douglas Tan, http://www.jr7sa.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 ]=

http://www.jr7sa.com
http://www.jr7sa.com/msn
http://www.jr7sa.com/vb
http://www.jr7sa.com/1
http://www.jr7sa.com/wordpress
http://jr7sa.com/vb/f2.html
http://jr7sa.com/vb/f3.html
http://jr7sa.com/vb/f4.html
http://jr7sa.com/vb/f15.html
http://jr7sa.com/vb/f56.html
http://jr7sa.com/vb/f57.html
http://jr7sa.com/vb/f17.html
http://jr7sa.com/vb/f50.html
http://jr7sa.com/vb/f38.html
http://jr7sa.com/vb/f21.html
http://jr7sa.com/vb/f23.html
http://jr7sa.com/vb/f43.html
http://jr7sa.com/vb/f39.html
http://jr7sa.com/vb/f44.html
http://jr7sa.com/vb/f46.html
http://jr7sa.com/vb/f49.html
http://jr7sa.com/vb/f27.html
http://jr7sa.com/vb/f28.html
http://jr7sa.com/vb/f40.html
http://jr7sa.com/vb/f54.html
http://jr7sa.com/vb/cv_rss_feeds.php
http://www.jr7sa.com/vb/archive/index.php/
http://jr7sa.com/vb/f47.html
http://jr7sa.com/vb/f35.html
http://jr7sa.com/vb/external.php?type=RSS2
http://jr7sa.com/vb/jr7sa.com_vb_sitemap.xml
http://jr7sa.com/vb/sitemap.php