Lost "root" password

RT Users
1

Hi everyone,

We lost a sysadmin recently that took off with the ‘root’ password of a
DEV RT install (using MySQL back-end). Is these a way to reset the
‘root’ password from the command line? I have ‘root’ at the OS level,
but not the RT ‘root’…

Thanks,
js.
Jean-Sebastien Morisset, Sr. UNIX Administrator jsmoriss@mvlan.net

2

Jean-Sebastien Morisset wrote:

Hi everyone,

We lost a sysadmin recently that took off with the ‘root’ password of a
DEV RT install (using MySQL back-end). Is these a way to reset the
‘root’ password from the command line? I have ‘root’ at the OS level,
but not the RT ‘root’…

Thanks,
js.

use phpmyadmin

Chaim Rieger

3

Jean-Sebastien Morisset wrote:

Hi everyone,

We lost a sysadmin recently that took off with the ‘root’ password
of a
DEV RT install (using MySQL back-end). Is these a way to reset the
‘root’ password from the command line? I have ‘root’ at the OS level,
but not the RT ‘root’…

Thanks,
js.

http://wiki.bestpractical.com/view/RecoverRootPassword

4

The RT internal user passwords are stored in rt3.Users as MD5 encrypted
strings.

You can reset the root password by any MySQL tool (phpMyAdmin or
command-line, for example).

The mysql command might be:

update rt3.Users set password = md5(‘newpass’) where Name = ‘root’;

Hope that helps…

Erik

5

Jean-Sebastien Morisset wrote:

Hi everyone,

We lost a sysadmin recently that took off with the ‘root’ password
of a
DEV RT install (using MySQL back-end). Is these a way to reset the
‘root’ password from the command line? I have ‘root’ at the OS level,
but not the RT ‘root’…

Thanks,
js.

RecoverRootPassword - Request Tracker Wiki

Thanks everyone!

I used the perl command from the Wiki and it worked fine. :slight_smile:

Thanks,
js.
Jean-Sebastien Morisset, Sr. UNIX Administrator jsmoriss@mvlan.net