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

    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
    Location
    Petaling Jaya, Malaysia
    Posts
    1
    Hi sunnyside,

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

    When you enable cookie authentication specify a passphrase in config.inc.php 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,

    Alan

Posting Permissions

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