At 10:54 AM -0400 6/21/01, Peter H. Burris wrote:
>Lately, I have been suffering the winds of misfortune with respect to user
>AND root password acceptance. It seems I have granted the root password
>correctly finally, but to date, though the SQL syntax gets accepted for
>changing the user password, the user can not log in WITH the -p switch;
>she CAN, however, log in without a password. I don't like that, even if
Delete the entries in the user table that have an empty password,
FLUSH PRIVILEGES, and try again. Also look for entries with a blank
user name and a host value of %. Delete those, too, and FLUSH PRIVILEGES.
>she is the ONLY person using that build and its host.
>
>None of this means anything without specifics, so here we go:
>
>I use mysqladmin shutdown to bring down the daemon and run
>
>safe_mysqld --skip-grant-tables &
>
>then at the mysql prompt, I use
>
>set password for some-user@localhost = PASSWORD("some-new-password");
>
>and get an ok. But when root does a 'su - some-user' and tries to log in
>with the user's password, an access-denied error results. The last time I
>did this, it worked just fine, for some reason, but I have no confidence
>in the process because I have successfully done this three times, but at
>some point, the user calls me and says she can not get into the database,
>did I change anything? In each case, I have not. To date, the command
>'mysqladmin -u some-user password foo' has yet to work, either. HELP?
>
>
>---------------------------------------------------------------------
>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
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
