我mysql安装好用phpmyadmin出错

netkoko

如下：
Server localhost
Error

MySQL said:


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

aspbiz

没有安装mysql-client 包。

井中月0221

解决方法:
CMD进入命令提示符窗口
cd c:\mysql
cd \bin
mysql
mysql>;SET PASSWORD FOR
    ->; 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
然后任意选着下面两种方法:
mysql>; UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
    ->; WHERE Host = 'some_host' AND User = 'some_user';
mysql>; FLUSH PRIVILEGES;
就可以了.

井中月0221

当然要注意在 config.inc.php
里把 $cfg['Servers'][$i]['auth_type']     = 'config';
改为
$cfg['Servers'][$i]['auth_type']     = 'http';

阴阳

好容易才明白！