<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<TITLE>Restore root password for rt3.0</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff
size=2>Something like:</FONT></SPAN></DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff size=2>UPDATE
rt3.user set password = MD5('password') WHERE username=
'root';</FONT></SPAN></DIV>
<DIV><SPAN class=546110822-29072003></SPAN> </DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff
size=2>...then change he password afterwords</FONT> </SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Kataria, Jitender .
[mailto:Jitender.Kataria@us.ngrid.com]<BR><B>Sent:</B> Tuesday, July 29, 2003
1:41 PM<BR><B>To:</B> rt-devel@lists.fsck.com<BR><B>Cc:</B>
rt-users@lists.fsck.com<BR><B>Subject:</B> [rt-users] Restore root password
for rt3.0<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi </FONT></P>
<P><FONT face=Arial size=2>By mistake I modified the root password in
Users table of rt schema .</FONT> <BR><FONT face=Arial size=2>Now I cannot
login to rt with root account ( which is the only account whic has all the
privileges)</FONT> <BR><FONT face=Arial size=2>How can I restore this
Id</FONT> </P>
<P><FONT face=Arial size=2>Thanks in advance</FONT> </P>
<P><FONT face=Arial size=2>Jitender</FONT> </P><FONT size=3><BR><BR>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.<BR></BLOCKQUOTE></FONT></BODY></HTML>