phpmyadmin连接mysql的问题，

rootding

局域网内，
mysql数据库在一台ip为100的机器上，
本人机器ip为88，我用phpmyadmin在linux底下可以连接到100上的mysql数据库，
但是到win下面就不行了，错误为：#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client


    但是我在win下用phpmyadmin连接本机的mysql数据库完全正确。

rootding

linux下：连本机，与200上的数据库都正确。
win下：连本机正确，连200上的，就有错误。
错误为：#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

谢谢高手指点

sleetdrop

你win下的php版本是什么啊。

jedipi

MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:

mysql Client does not support authentication protocol requested by server; consider upgrading MySQL client

To solve this problem, you should use one of the following approaches:

    * Upgrade all client programs to use a 4.1.1 or newer client library.
    * When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
    * Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

rootding

版本如下：
      phpMyAdmin 2.6.2-pl1
      mysql-5.0.4-beta
同样的版本linux是可以连接的，win下就不可以了。

rootding

php的版本：4.3.11

parset

Post by rootding
版本如下：
      phpMyAdmin 2.6.2-pl1
      mysql-5.0.4-beta
同样的版本linux是可以连接的，win下就不可以了。

你这样的配合就是登陆以后进不了界面,呵呵,我试过了,我改成PHP5就没有问题了，呵呵,另外为什么数据库用高版本的,而且是测试版本的,而PHP不使用高版本的稳定版呢?

parset

php.ini开启下面的扩展
extension=php_mbstring.dll

extension=php_mysql.dll
extension=php_mysqli.dll
并且将phpmyadmin里面的 config.inc.php:
$cfg['Servers'][$i]['extension']     = 'mysqli';