[rt-users] Lost "root" password...

[Peterson, Erik]

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


> From: Jean-Sebastien Morisset <jsmoriss at mvlan.net>
> Date: Mon, 4 Aug 2008 17:31:56 +0000
> To: RT Users <rt-users at lists.bestpractical.com>
> Subject: [rt-users] Lost "root" password...
> 
> 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 at mvlan.net>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com