[rt-users] lost root password

[Narendra Mehta]

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
>