RE: Find username password on tables

2005-10-05 Thread Jay Paulson
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 M

RE: Find username password on tables

2005-10-05 Thread Sujay Koduri
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

Re: Find username password on tables

2005-10-05 Thread Arno Coetzee
Scott Purcell wrote: 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.