Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Question Unanswered: Password problem in PhpMyAdmin

    My system: win2000 + MySQL 4.1.0 + PHP4

    After I installed Phpmyadmin, everything was fine and it used the default setting to connect MySQL (the username: root, and password is empty).

    I tried to create a new user with password in Mysql (I checked it out from DB, it was there after I created). In the phpmysql, I changed the usr and pwd, but couldn't display the right index page in phpmyadmin.
    Error message:
    #1249 - Client does not support authentication protocol requested by server. Consider upgrading MySQL client

    I also want to have a login page when I use the phpmyadmin, I changed $cfg['Servers'][$i]['auth_type'] = 'cookie'; leave the usr and pwd empty, Also get the error message:
    The configuration file now needs a secret passphrase (blowfish_secret).
    Same result when I filled the right usr and pwd

    So, what happened? Would you help me to figure it out?

  2. #2
    Join Date
    Apr 2002
    Petaling Jaya, Malaysia
    Hi sunnyside,

    I don't know about the first part, but as for cookie authentication...

    When you enable cookie authentication specify a passphrase in at the following parameter:

    $cfg['blowfish_secret'] = 'xxxxx';

    This is a key that the password supplied from the web interface is encrypted so it isn't just sent as plain text.

    Yes, leave user and pass blank.

    Hope this helps,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts