Server setup hints

[Ric Moore]

On Tue, 2006-08-08 at 16:43 -0500, Ben Duncan wrote:
> Ric:
> 
> http://www.cyberciti.biz/nixcraft/vivek/blogger/2006/04/recover-mysql-root-password.php

That worked! Thanks! There was one catch:

mysql> update user set 
password=PASSWORD("NEW-ROOT-PASSWORD") 
where User='root';
mysql>

That's how the example looked at the site. If you had some sort of idea
just what it wanted, it would have been easier. Once I literally used
the example as one line as:

mysql> update user set password=PASSWORD("mypasswd") where User='root';

... then it worked! Whew! Took a couple of tries. I've used Stanton
Finley's site:  http://www.stanton-finley.net  and his how-to's are
good. He makes allowances for complete-idiots and is a great example of
how to How-To, to my perceptions. 

>From experience when I saw mysql> then three lines of text before the
next mysql> prompt I knew that anything between was on one line,
usually. Many users don't. The information worked flawlessly and I am
indebted. It took me several tries before I got the information to work,
so if they could make it plainer what is need to do, it would be even
better! 

Thanks again! Ric

-- 
================================================
My father, Victor Moore (Vic) used to say:
"There are two Great Sins in the world...
...the Sin of Ignorance, and 
...the Sin of Stupidity.
Only the former may be overcome." R.I.P. Dad.

Linux user# 44256
Sign up at: http://counter.li.org/
http://www.sourceforge.net/projects/oar
http://www.wayward4now.net

================================================