Or if you have any applications that are accessing this database you could look at the config files for it and most likely the password will be there.
jay > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
