6 replies to this topic

[Artluo100]

After I installed phpMyAdmin and tried logging in with the root password, I get this :

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client


I already installed mySQL administrator and enabled old passwords.


Any help would be appreciated.

Oh yeah I have :

mySQL version 4.1.11-nt
mySQL client 5.04
Apache 2.0.54
PHP 4.3.11
phpMyAdmin 2.6.1-pl3

Edited by microscopic^earthling, 22 June 2005 - 05:19 AM.

[miCRoSCoPiC^eaRthLinG]

Hey,
I had the same problem with MySQL+PHP - and it seems the problem stems from PHP not being compiled with support for the MySQL transactions - that's the only logical explanation I found on the MySQL forums.

What i did was blindly recompile PHP with --with-mysqli (MySQL interface) option - and that made it work. I'd found out about this partly from PHP & partly from MySQL forums and I'm still looking for a proper clear-cut explanation - but none that I've come across has satisfied me. Try posting the same on the MySQL forums too and see if you get any decent response.

The other fact I know about this error - is that starting from version 4.1.x of MySQL, the password hash that is used for mysql authentication was increased from 16 to 41 bytes. Thus older clients cannot talk to the newer servers because of the disparity in authentication methods. From this I deduced that the version of PHP (both you and me are using) is compiled to support the older authentication protocol and hence cannot converse with mysql servers starting from 4.1

There's an alternate fix for this - if you don't want to go into the hassle of recompiling php with the new mysql client libraries. Find out your my.cnf - MySQL configuration file and under the [mysqld] section add the statement: old-passwords - and then restart the MySQL server. This will make it fall back to the older 16-byte authentication method and PHP will work fine with it.

Hope this helps to some extent.
Regards,
m^e

[chaosx2x]

i've a similar problem, but ii don't give me any errors, i put my root password but it ask me in loop user e pass

[Casanova]

well i too faced same problem..! And i visited mysql forums.! Thats nothing but Old Lib files in Mysql..! Upgrade the library Files there and it will work fine.!

Else shortcut method is In your mysql administrator Remove ur passwords and save.!

Then You wont ever get that or any other error.!

And remember while logging in phpmyadmin

login-root
password-{leave blank}
And enter..!

Also configure your scripts without password.. Hope this works out for you!

[fabiocardoso]

Add a line "php_mysqli.dll" on PHP.INI to load the lib correct.

[Klass]

Add a line "php_mysqli.dll" on PHP.INI to load the lib correct.

<{POST_SNAPBACK}>

that will not fix the issue,

1. Download the Full PHP zip:
http://us3.php.net/g...p/from/a/mirror
2. Extract to your desktop
3. upload the ext directory to your PHP directory
i.e. C:\PHP\
4. Copy the libmysql.dll from zip above & paste to C:\PHP\ext & C:\WINNT\System32 or C:\Windows\System32

C:\ is the default location if you have changed this on the installation then you need to put them in the correct places.

5. Edit php.ini
Find:

; Directory in which the loadable extensions (modules) reside.
extension_dir = "/"

Replace with:

; Directory in which the loadable extensions (modules) reside.
extension_dir = "C:\PHP\ext"

Find:

;extension=php_mysql.dll

Replace with:

extension=php_mysql.dll

[DivineZero]

Maybe you dont have acess rights to do so?