[rt-users] SQL fix

[Beachey, Kendric]

> -----Original Message-----
> From: Matt Disney [mailto:matthew.disney at fedex.com]
> Sent: Thursday, March 28, 2002 7:56 AM
> To: rt-users at lists.fsck.com
> Subject: Re: [rt-users] SQL fix 
> 
> After you get logged into mysql, you'll be dropped into an 
> interactive mysql shell. That's where you type the update statement
> Jesse sent out:
> 
>    update Users set Password = '*LOCK*' where Password is null;
> 
> Type exit to quit mysql and that should do it.

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.
--
Kendric Beachey
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20020328/dc6b034c/attachment.htm>