Someone the other day said this worked:
started safe_mysqld with --skip-grant-tables and then did:
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD('abc') WHERE User='root'
-> AND Host='whichever host you want to match'
----- Original Message -----
From: "Mike Ryerse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 06, 2001 12:23 PM
Subject: Password error
> I have resently installed mysql 3.23.41 on Redhat 7.1
>
> When I installed it, I could access the example
> databases 'mysql' and 'test'. Mysql said to change
> the root password right away with :
> mysqladmin -h host -u root -p password 'new password'
>
> so I did it, but now mysql won't let me log in as any
> user, not even root.
>
> I have tried to re-install with rpm -i --force, and
> uninstall with rpm -e, neither will change the
> permissions of mysql.
>
> What should I do?
>
> -Mike Ryerse
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
