Username you can get it from the user table in Mysql. But I don't think atleast after MySQL 4.1 there is a way to retrieve paswords in MySQL as it uses its own encryption algo to encrypt passwords. You have to reset(make that passwd field to null in the mysql.user table) and add a new password(use grant) to use that.
sujay -----Original Message----- From: Scott Purcell [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 6:39 PM To: mysql@lists.mysql.com Subject: Find username password on tables Hello, A while back, I created a database, and performed the following: GRANT ALL ON util_db.* to XXX identified by "XXX"; Problem is, a year later, I need to find the username and password, so I can write to these tables. Can this be accomplished, I am the root user. Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
