I recently installed a MySQL DB on my own computer, and I downloaded phpMyAdmin

But when I try to run phpMyAdmin, I get the following error:

Welcome to phpMyAdmin 2.6.1-pl3

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.
Error

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

Does anybody know what the problem is? I'm running an Apache server on Win XP Home

    Hi Snoopie,

    I recently posted this for helldr...... hope it is what your looking for;

    We all have problems with new stuff - it does not make us stupid. Personally, I like to try and learn one new thing each day....

    There are details for the quick install here .

    Also you can try this for the configuration. You should just find that you need to get this right.

    Cheers,

    Neil.

      Hmm.. I changed the auth_type to cookie, now I can enter username and password

      I set username to root and password to the one i set in the mysql config wizard.. and i get the same error..

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

      I'm running MySQL 4.1

        OK Snoopie,

        Silly question on my behalf, nut have you gone all the way through the configuration file and changed stuff like;

        $cfg['Servers'] array
        $cfg['Servers'][$i]['host'] string
        $cfg['Servers'][$i]['connect_type'] string

        etc......

        Cheers,

        Neil.

          $cfg['Servers'][$i]['host'] = 'localhost';
          $cfg['Servers'][$i]['port'] = '';
          $cfg['Servers'][$i]['socket'] = '';
          $cfg['Servers'][$i]['connect_type'] = 'tcp';
          $cfg['Servers'][$i]['extension'] = 'mysql';
          $cfg['Servers'][$i]['compress'] = FALSE;
          $cfg['Servers'][$i]['controluser'] = '';
          $cfg['Servers'][$i]['controlpass'] = '';
          $cfg['Servers'][$i]['auth_type'] = 'cookie';
          $cfg['Servers'][$i]['user'] = 'root'
          $cfg['Servers'][$i]['password'] = 'mypass';

            Write a Reply...