[rt-users] lost root password

[AJ]

update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where Name='root';

that should reset you to root.

Or look at the password string of a user whose pw you still know and set the
password field to that.



-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Narendra
Mehta
Sent: Monday, January 26, 2004 4:05 PM
To: Todd Chapman
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] lost root password


Thanks.  I tried that.  mysql responds as:

Query OK, 1 row affected (0.02) sec
Rows matched: 1 Changed: 1 Warnings:0

However, logging into the 'rt' as 'root' still gives 'your username or
password is incorrect'.  Logging as non-root is working.  I tried both
blank and non-blank password.  Rebooted.

Thanks.

*-------------------------------------------------------------------*
|Narendra Mehta             Email: Narendra.Mehta at sce.carleton.ca   |
|Computer Systems Manager   Tel: (613) 520-5737 Fax: (613) 520-5727 |
|                                                                   |
|Carleton University, Systems and Computer Engineering Department   |
|1125 Colonel By Drive, Ottawa, Ontario, Canada K1S 5B6             |
*-------------------------------------------------------------------*


On Mon, 26 Jan 2004, Todd Chapman wrote:

> mysql> use rt3
> Database changed
> mysql> update Users set Password='' where Name='root';
>
> On Mon, Jan 26, 2004 at 02:45:58PM -0500, Narendra Mehta wrote:
> >
> > RT version 3.0.6 on Redhat 9.
> >
> > I can't seem to login to my RT 'root' account.  Could someone tell me
how
> > to reset it at command line?
> >
> > Thank you.
> >
> > *-------------------------------------------------------------------*
> > |Narendra Mehta             Email: Narendra.Mehta at sce.carleton.ca   |
> > |Computer Systems Manager   Tel: (613) 520-5737 Fax: (613) 520-5727 |
> > |                                                                   |
> > |Carleton University, Systems and Computer Engineering Department   |
> > |1125 Colonel By Drive, Ottawa, Ontario, Canada K1S 5B6             |
> > *-------------------------------------------------------------------*
> >
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.bestpractical.com
> > http://lists.bestpractical.com/mailman/listinfo/rt-users
> >
> > Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> _______________________________________________
> rt-users mailing list
> rt-users at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>
_______________________________________________
rt-users mailing list
rt-users at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm