MySQL password

[R Kimber]

On Thu, 17 Jun 2010 14:06:25 +0100
Dave Howorth wrote:

> The only reason I can think of for it to deny access is that there is in
> fact already a password. I don't know how ubuntu configures mysql but I
> did find this page
> <http://www.ubuntugeek.com/reset-the-root-password-on-mysql.html> which
> explains about the ‘debian-sys-maint’ and its password in
> /etc/mysql/debian.cnf and that all seems to work on my machine, so you
> could try that.

Thanks.  I tried the recommended command, and got:

>sudo /etc/init.d/mysql reset-password

Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql reset-password

The script you are attempting to invoke has been converted to an Upstart
job, but reset-password is not supported for Upstart jobs.

  :-)

Maybe a remove and re-install mysql is called for, but are there other
things that would be affected by doing this?

- Richard
-- 
Richard Kimber
Political Science Resources
http://www.PoliticsResources.net/