resetting mysql root password on 10.04

[Mike McMullin]

On May 23, 2010 12:06:04 pm Markus Schönhaber wrote:
> 23.05.2010 17:43, Mike McMullin:
> >   I'm trying to migrate my mythtv over to 10.04 but am having 
problems
> > with mysql, what I would like to do is reset the root password for 
mysql
> > then reset the mythconverg password.  Any ideas on how to do 
this?
>
> <http://dev.mysql.com/doc/refman/5.1/en/resetting-
permissions.html#resettin
>g-permissions-unix>
>
> --
> Regards
>   mks

  For some odd reason following the instructions on locating the .pid file 
and killing the process fails.  Each time that I try and invoke the 
mysql_safe command with the init file option I get an error telling me 
that a mysqld process already exists.  I decided to beat it dead by 
uninstalling everything and then reinstalling everything associated with 
it.  I now have the access that I wanted.  On to other problems with the 
migration.