<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4807.2300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=386364217-03032003>From:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><A
href="http://forums.devshed.com/archive/4/2001/06/4/17391">http://forums.devshed.com/archive/4/2001/06/4/17391</A></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV>Kill the mysqd, and restart it with the option --skip-grant-tables (you
have root access, right?).<BR>Now you can log in to mysql without a password,
meaning that you can update your root password to whatever you want. Then
restart the mysqld again as normal to use the new password. <BR></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Chuck
[mailto:chuckeal@attbi.com]<BR><B>Sent:</B> Monday, March 03, 2003 11:25
AM<BR><B>To:</B> tclug-list@mn-linux.org<BR><B>Subject:</B> [TCLUG] Mysql
Problems<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>As I was setting up mysql server on a Red Hat 8.0
machine last night I believe that I miss typed the root mysqladmin password
when I set it.</FONT></DIV>
<DIV><FONT face=Arial size=2>Can anyone tell me how I can clear this as I
cannot log into the account.</FONT></DIV>
<DIV><FONT face=Arial size=2>Thank you </FONT></DIV>
<DIV><FONT face=Arial size=2>Chuck Licha</FONT></DIV></BLOCKQUOTE></BODY></HTML>