myqsl dummy needs help

[Gene Heskett]

On Monday 16 February 2009, Matthew Flaschen wrote:
>Gene Heskett wrote:
>> On Monday 16 February 2009, Steve Searle wrote:
>>> Around 02:33pm on Monday, February 16, 2009 (UK time), Gene Heskett 
scrawled:
>>>> 3.# mysql -u root mysql
>>>
>>> 3.# mysql -u root mysql -p
>>>                        ^^
>>>
>>> The -p will cause you to be prompted for root's password.  What you have
>>> tried does not supply the password.
>>>
>>> Steve
>>
>> Unforch Steve, same error:
>>
>> [root at coyote etc]# mysql -u root mysql -p
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>> password: YES)
>> [root at coyote etc]# mysql -u root mysql -p
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>> password: YES)
>>
>> in each case I entered my root pw at the prompt.
>
>Your root password is not MySQL's root password.  However, you can
>change that if you choose (or set whatever pw you want).  See the
>instructions at
>http://www.cyberciti.biz/tips/recover-mysql-root-password.html (though
>there are other methods)
>
>Matt Flaschen

I did all of that sites steps, Matt, with no reported errors, but when I stop 
the special session and restart the regular session, the exact same error is 
returned:
[root at coyote etc]# /etc/init.d/mysqld stop
STOPPING server from pid file /var/run/mysqld/mysqld.pid
090216 10:53:05  mysqld ended

Stopping MySQL:                                            [  OK  ]
[1]+  Done                    mysqld_safe --skip-grant-tables
[root at coyote etc]# /etc/init.d/mysqld start
Starting MySQL:                                            [  OK  ]
[root at coyote etc]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES)

Thanks Matt.

-- 
Cheers, Gene
"There are four boxes to be used in defense of liberty:
 soap, ballot, jury, and ammo. Please use in that order."
-Ed Howdershelt (Author)
We are all worms.  But I do believe I am a glowworm.
		-- Winston Churchill