我mysql安裝好用phpmyadmin出錯(cuò)

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進(jìn)入命令提示符窗口
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

當(dāng)然要注意在 config.inc.php
里把 $cfg['Servers'][$i]['auth_type']     = 'config';
改為
$cfg['Servers'][$i]['auth_type']     = 'http';

陰陽(yáng)

好容易才明白！