List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 21 2001 3:25pm
Subject:Re: password peculiarities
View as plain text  
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 <mysql-thread77273@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Paul DuBois, paul@stripped
Thread
password peculiaritiesPeter H. Burris21 Jun
  • Re: password peculiaritiesPaul DuBois21 Jun