Index
 |
phpMyAdmin-MySQL Error #1251:client Authentication - Stupid error | ||
Discussion by Artluo100 with 6 Replies.
Last Update: September 1, 2005, 8:09 pm | |||
 |
|||
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
#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
Tue Jun 21, 2005 Reply New Discussion
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
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
Wed Jun 22, 2005 Reply New Discussion
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 
Wed Jun 29, 2005 Reply New Discussion
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!
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!
Mon Jul 4, 2005 Reply New Discussion
Add a line "php_mysqli.dll" on PHP.INI to load the lib correct.
Tue Aug 16, 2005 Reply New Discussion
QUOTE (fabiocardoso)
Add a line "php_mysqli.dll" on PHP.INI to load the lib correct.
[post="48801"]<{POST_SNAPBACK}>[/post]
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:
CODE
; Directory in which the loadable extensions (modules) reside.extension_dir = "/"
Replace with:
CODE
; Directory in which the loadable extensions (modules) reside.extension_dir = "C:\PHP\ext"
Find:
CODE
;extension=php_mysql.dllReplace with:
CODE
extension=php_mysql.dllTue Aug 16, 2005 Reply New Discussion
Maybe you dont have acess rights to do so?
Thu Sep 1, 2005 Reply New Discussion
 |
 |
|
 |
 |
| Reply / Comment | Ask a Question? | Share / Bookmark | E-Mail a Friend |
 Hosting A Server On Database I'm a total noob at databases (6)
|
(5) Tutorials Of Setting Up MySQL DBs On Your System ? 
|