Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!
Replying to phpMyAdmin-MySQL Error #1251:client Authentication
Posted 01 September 2005 - 08:09 PM
Posted 16 August 2005 - 02:58 PM
that will not fix the issue,
Add a line "php_mysqli.dll" on PHP.INI to load the lib correct.
1. Download the Full PHP zip:
2. Extract to your desktop
3. upload the ext directory to your PHP directory
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
; 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:
Posted 16 August 2005 - 02:33 PM
Posted 04 July 2005 - 07:30 AM
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
Also configure your scripts without password.. Hope this works out for you!
Posted 29 June 2005 - 01:12 PM
Posted 22 June 2005 - 04:51 AM
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.
Posted 21 June 2005 - 10:42 PM
#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