Hi

I faced this issue once, I forgot the root password and was unable to
recover it and since then I was thinking of how to resolve this issue
and later when I did resolved I thought to post it on my blog so that
others should also benefit from it.

Here is the link : http://wp.me/p1pXSt-k

View and review.

Thanks
Vineet Daniel

Twitter : @vineetdaniel

On Thu, 26 May 2011 03:46:43 -0700 (PDT), vd wrote:
FFS, the mysql doco tells you how to do this *as part of the initial
setup*. It's no mystery.

--
Every normal man must be tempted at times to spit upon his hands, hoist
the black flag, and begin slitting throats.
-- HL Mencken

On 5/26/2011 6:46 AM, vd wrote:
In addition to what Peter said, you don't need to edit any files, and
your method can change with different database releases.

The correct way to do it is documented at
http://dev.mysql.com/doc/refman/5.5/...ermissions.htm.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Peter H. Coffin wrote:

Come on - the OP was trying to contribute something positive...

But while were on the subject, I don't think the method in the blog is the
best way.

This would probably be the definitive way and it does work, because I had to
do it myself the other week.

http://dev.mysql.com/doc/refman/5.0/...tml#resetting-
permissions-unix

It's also worth mentioning that on debian/ubuntu systems there is likely an
/etc/mysql/debian.cnf file with a root equivalent user+password that can be
used to reset real root without needing to stop the server (had to do this
too as some joker had disallowed root (AT) localhost (DOT)

Cheers,

Tim

--
Tim Watts

On 5/26/2011 11:29 AM, Tim Watts wrote:
Yes, he was trying to contribute something positive, which is good. He
missed the boat on this one, but you do have to give him credit for
trying to help.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================