<!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 6.00.2800.1400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Greetings!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Working through Jarod's install, and at Step 13 Set
up MySQL, I had a cut and paste error to the console.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I ran this command:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># mysql -u root mysql</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>got the mysql prompt. Cut and pasted this
command into the console, but when I pasted I had grabbed part of the next line
too (</FONT>mysql> FLUSH):</DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>mysql> <FONT face="Times New Roman"
size=3>UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE
user='root';</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Apparently the part of the next line set the
password...</FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman"
size=3></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2>Not thinking anything bad had happened, I ran the next two
commands:</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3>mysql> FLUSH
PRIVILEGES;<BR>mysql> quit </FONT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman"
size=3></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2>Now I cannot log into mysql as root, as it tells me the root
password is bad. I've tried all sorts of combinations of the real root
password, no password, and the part of the line that got added in by
accident.</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2>Is there any way to clear the root password and reset it or am
I going to have to go the reinstall route?</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2>Thanks for your time.</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3><FONT
face=Arial size=2>Regards,
Bill</FONT></DIV></FONT></FONT></FONT></DIV></BODY></HTML>