<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [rt-users] SQL fix </TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>> -----Original Message-----</FONT>
<BR><FONT SIZE=2>> From: Matt Disney [<A HREF="mailto:matthew.disney@fedex.com">mailto:matthew.disney@fedex.com</A>]</FONT>
<BR><FONT SIZE=2>> Sent: Thursday, March 28, 2002 7:56 AM</FONT>
<BR><FONT SIZE=2>> To: rt-users@lists.fsck.com</FONT>
<BR><FONT SIZE=2>> Subject: Re: [rt-users] SQL fix </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> After you get logged into mysql, you'll be dropped into an </FONT>
<BR><FONT SIZE=2>> interactive mysql shell. That's where you type the update statement</FONT>
<BR><FONT SIZE=2>> Jesse sent out:</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> update Users set Password = '*LOCK*' where Password is null;</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Type exit to quit mysql and that should do it.</FONT>
</P>
<P><FONT SIZE=2>If your mysql setup is like mine, you'll have to do "use rt2;" first before you can do that update statement. Otherwise it won't know which database you're talking about.</FONT></P>
<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Kendric Beachey</FONT>
</P>
</BODY>
</HTML>