Lost root password

RT Users
1

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@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 |

2

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@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@lists.bestpractical.com
The rt-users Archives

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

3

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@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@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@lists.bestpractical.com
The rt-users Archives

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

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

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

4

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.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Narendra
Mehta
Sent: Monday, January 26, 2004 4:05 PM
To: Todd Chapman
Cc: rt-users@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@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 |

mysql> use rt3
Database changed
mysql> update Users set Password=‘’ where Name=‘root’;

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@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@lists.bestpractical.com
The rt-users Archives

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

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

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

rt-users mailing list
rt-users@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