Hi all,

I am trying to get phpmyadmin working with mysql but I get the below errors...
Why is this??

"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server."

and...

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

changes in config.inc.php file:

$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'pword';

Any ideas if I am missing something??

    obrienkev wrote:

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

    the mysql client library in your version of PHP is not compatible with your mySQL version. you are likely using an older version of PHP and a newer version of mySQL. upgrade your PHP (if you can).

      using php4.4 and mysql 5.0.26

      should i downgrade mysql??

        obrienkev wrote:

        should i downgrade mysql??

        again, i would suggest you upgrade PHP. i just installed PHP 5.2.0 and the bundled mySQL Client API version is 5.0.22.

          Either upgrade PHP, or rebuild your existing PHP against the appropriate client library for MySQL.

          Oh yes, and don't expect to use PHPMyAdmin for anything critical (or indeed, important) and have it work. It has many flaws- do not use it to enter or maintain production data or backup or restore production data.

          Mark

            Write a Reply...