Jump to content
xisto Community
Artluo100

phpMyAdmin-MySQL Error #1251:client Authentication Stupid error

Recommended Posts

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 clientI already installed mySQL administrator and enabled old passwords. Any help would be appreciated.Oh yeah I have :mySQL version 4.1.11-ntmySQL client 5.04Apache 2.0.54PHP 4.3.11phpMyAdmin 2.6.1-pl3

Edited by microscopic^earthling (see edit history)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 phpmyadminlogin-rootpassword-{leave blank} And enter..! Also configure your scripts without password.. :P Hope this works out for you!

Share this post


Link to post
Share on other sites

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/get/php-5.0.4-Win32.zip/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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.