MySQL install password?

[stan]

On Sat, Jan 10, 2009 at 11:37:15AM -0500, steve wrote:
> stan wrote:
> > I am trying to get ampache running on my Ubuntu machine. This package uses
> > MySQL. I looked at the MySQL 5.0 docs in /usr/share/docs, and it syas there
> > that I should be able to set the MySQL root user password with:
> > 
> > /usr/bin/mysql -u root -D mysql -e "update user set
> > password=password('new-password') where user='root'"
> > 
> > But when I try that, it fails, saying I need a passwrd. How can I find out
> > what password got set by the installer?
> > 
> 
> try this:
> 
> http://www.ubuntugeek.com/reset-the-root-password-on-mysql.html
> 
Well, I have really crreated a mess now :-( Reading further down that
article I ran acroos what appeared to be the solutin. I ran it, before I
ead on down further. Unfrotuantely the instruction there changed the
password for _all_ users!! So, at that point I panicked. I have tried
removeing the  mysql-server-5.0  package, and reinstalling it, but that
fails.

Can anyone help me out of this mess ?
-- 
One of the main causes of the fall of the roman empire was that, lacking
zero, they had no way to indicate successful termination of their C
programs.