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@coyote etc]# mysql -u root mysql -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> [root@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@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@coyote etc]# /etc/init.d/mysqld start
Starting MySQL: [ OK ]
[root@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