MySQL install password?

[stan]

On Sat, Jan 10, 2009 at 12:21:47PM -0500, steve wrote:
> stan wrote:
> > 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
> > 
> > Looks handy, but it does not seem to work in Intrepid
> > 
> > root at boo-boo:/etc/init.d#  /etc/init.d/mysql reset-password
> > Usage: /etc/init.d/mysql start|stop|restart|reload|force-reload|status
> > 
> 
> duh, sorry, wrong one, this will work
> 
> 
> sudo dpkg-reconfigure mysql-server-5.0
> 
Unfortunately, I have made a real mess of things at this time. How can I
completly remove all traces of MySQL, so that I can do a clean re-install?
-- 
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.