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
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
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.