could not open main database: MySQL-Password Issue
Dominik Reusser <[email protected]> Wed, 21 Mar 2007 13:21:33 +0100
| Newsgroups | gmane.text.refdb.general |
|---|---|
| Organization | Uni Potsdam |
| Message-ID | <[email protected]> |
Today I encountered the following problem:
For one user, I always got the error:
> could not open main database
even though rights were appropriate. And login worked for other users. In the
log-file, I found:
> 1251: Client does not support authentication protocol requested by server;
consider upgrading MySQL client
I was able to fix the problem by reseting the password in mysql to an older
password-version:
SET PASSWORD FOR 'someuser'@'localhost' = OLD_PASSWORD('*******')
Is this a problem specific to my set-up or does refdbd fail to check what
authentication protocol should be used?
Regards
--
Dominik Reusser
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV