myqsl dummy needs help

[Matthew Flaschen]

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