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.


Thanks,
Scott

use the mysql database and look in the user table .. you will be able to see all the users there , as well as the privileges. you will have to reset the password for the user you want to use... use the 'grant' statement to reset the password.

hope this helps.

--
Arno Coetzee
Developer
Flash Media Group
Office : 2712 342 7595
Mobile : 2782 693 6180


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to