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

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

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. :D

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. :D
...never said you were a newb... 8O

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. :D

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. :D

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. :D