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.

Jeff

Thanks for the reply .
I tried to set the password with the MD5 option , it is still not
working . Infact I noticed
with MD5 it is setting the pasword whose length ( in envcrypted format)
is too long , longer then the reqular user . Do I need to use someother
encryption formation to change the password in RT3.0.4

Here is the data from the Users table

| root | 5f4dcc3b5aa765d61d8327deb882cf99 |
| test | dDBr7H7iUYUA6VzlLPolkA |
| test1 | gZrvD5/q9BCeqAvcs9SFMA |
|

Thanks
Jitender-----Original Message-----
From: Hodge, Jeff F (ECIII) [mailto:Jeff.Hodge@yuma.army.mil]
Sent: Tuesday, July 29, 2003 6:13 PM
To: Kataria, Jitender .; rt-devel@lists.fsck.com
Cc: rt-users@lists.fsck.com
Subject: RE: [rt-users] Restore root password for rt3.0

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@us.ngrid.com]
Sent: Tuesday, July 29, 2003 1:41 PM
To: rt-devel@lists.fsck.com
Cc: rt-users@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.

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.

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@us.ngrid.com]
Sent: Tuesday, July 29, 2003 1:41 PM
To: rt-devel@lists.fsck.com
Cc: rt-users@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.