Page 1 of 1
MySQL server connection problems
Posted: Thu Jul 07, 2005 6:23 pm
by evilmonkey
Hi,
I wasn't quite sure on where to post this. Anyway, I just installed a test server on my home machine: Apache 1.3.29, PHP 4.3, and MySQL 4.1. I ran phpmyadmin, and it told me this:
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
I tried connecting manually through PHP to no avail. I also tried all the possible auth methods in PHPmyADMIN, also to no avail. What can I do? Thanks

Posted: Thu Jul 07, 2005 6:26 pm
by Burrito
Code: Select all
mysql>set password for user@host = old_password('password');
Posted: Thu Jul 07, 2005 6:34 pm
by timvw
The answer was to check the mysql manual... Or search this forum...
Posted: Thu Jul 07, 2005 6:36 pm
by Burrito
timvw wrote:The answer was to check the mysql manual... Or search this forum...
doh! my bad

Posted: Thu Jul 07, 2005 9:32 pm
by evilmonkey
Hmm, I should know this, but how do I get to MySQL in the command line? This is a windows box. Going to mysqld-nt.exe hangs the DOS box for a few seconds, then quits without giving me a chance to type anything. Thanks for the answers, some more productive than others. (I'm not some noob, you know, I have over 500 posts

)
Thanks.

Posted: Thu Jul 07, 2005 10:37 pm
by Burrito
evilmonkey wrote:(I'm not some noob, you know, I have over 500 posts

)
Thanks.

...never said you were a newb...
Code: Select all
c:\MySQL\bin\mysql -u root -p
// then type in password
Posted: Fri Jul 08, 2005 11:13 am
by evilmonkey
Ah, that worked, thank you very much.
It looks like I have to do this for every user. How come?
I said I'm not a noob because "rtfm" is usually the answer that noobs get. Burrito, you were actually very helpful. Thanks.

Posted: Fri Jul 08, 2005 11:26 am
by timvw
Certainly from someone that is not new... I would expect him to do a little websearch... I typed "mysql Client does not support authentication protocol" in the google lucky box....
The first link returned:
http://dev.mysql.com/doc/mysql/en/old-client.html
Posted: Fri Jul 08, 2005 11:32 am
by evilmonkey
Hehe, alright, that link actually explained the "why" portion of my question. Sorry about not doing the research. Thanks everyone.
