[rt-users] Restore root password for rt3.0

[Hodge, Jeff F (ECIII)]

Your root Mysql (or whatever DB) account should log you into the database
and then open the users table within the rt3 DB and frind the root user for
RT.  Then update the user password for the root RT user.  Make sure you use
MD5() to encrypt the password in your update statement.
 
Something like:
 
UPDATE rt3.user set password = MD5('password') WHERE username= 'root';
 
...then change he password afterwords 

-----Original Message-----
From: Kataria, Jitender . [mailto:Jitender.Kataria at us.ngrid.com]
Sent: Tuesday, July 29, 2003 1:41 PM
To: rt-devel at lists.fsck.com
Cc: rt-users at lists.fsck.com
Subject: [rt-users] Restore root password for rt3.0



Hi 

By mistake  I modified the root password in Users table of rt schema . 
Now I cannot login to rt with root account ( which is the only account whic
has all the privileges) 
How can I restore this Id 

Thanks in advance 

Jitender 



This e-mail and any files transmitted with it, are confidential to National
Grid and are intended solely for the use of the individual or entity to whom
they are addressed. If you have received this e-mail in error, please
contact the National Grid USA Enterprise Support Center on 508-389-3375 or
315-428-6360.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030729/9d1ad517/attachment.htm>