resetting mysql root password on 10.04

[Mike McMullin]

On May 24, 2010 07:43:48 pm Hal Burgiss wrote:
> On Mon, May 24, 2010 at 11:26 AM, Mike McMullin <mmcmullin at cogeco.ca> wrote:
> >  Yes it does, openSuSE has actual scripts in the /etc/init.d directory
> > that give other information, such as status, which would have been nice
> > in this situation, as issuing sudo /etc/init.d/mysql stop did not seem to
> > work, the .pid file just changed it's contents, which indicates that
> > something kept restarting it, but I have no idea what mythtv perhaps?.
>
> still works ...
>
> sudo /etc/init.d/mysql status
>  * /usr/bin/mysqladmin  Ver 8.42 Distrib 5.1.37, for debian-linux-gnu on
> i486 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version          5.1.37-1ubuntu5.1
> Protocol version        10
> Connection              Localhost via UNIX socket
> UNIX socket             /var/run/mysqld/mysqld.sock
> Uptime:                 1 day 1 hour 25 min 47 sec

  Nice that it works for you, but I just retried it and it doeos not return 
anything that looks like what you get, it informs me that this script has been 
converted to an upstart and to use service instead.
service mysql status, returns start/running, process 942, so it does indicate 
that it is running in that it possesses a pid.