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
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