Page 3 of 3 First 123
  • Jump to page:
    #31
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2004
    Posts
    204
    Rep Power
    0
    hey guys i need some help with setting windows 2003 IIS with mysql 5 what do i do to rewire the password thingie??
  2. #32
  3. Hockey face
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    St. Catharines, Canada
    Posts
    8,144
    Rep Power
    1316
    Originally Posted by chas2u
    hey guys i need some help with setting windows 2003 IIS with mysql 5 what do i do to rewire the password thingie??
    Are you getting the exact same error message as the title of this thread? if so read through the thread. If not your question does not belong in this thread.
  4. #33
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Posts
    3
    Rep Power
    0
    Go to MySQL Command Prompt and write:

    mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
    -> WHERE Host = 'some_host' AND User = 'some_user';
    mysql> FLUSH PRIVILEGES;


    This will reset the password to pre-4.1 style password. And it will compatible for working with PHP.
  6. #34
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2010
    Location
    California
    Posts
    3
    Rep Power
    0
    Let me understand, your saying that the problem is that a number of programs / applications haven't been updated to deal with this hashing algorithm, so what we're telling MySQL to do is to use the old 16-byte hash (SET PASSWORD = OLD_PASSWORD('devshed') ), or to assume that all the passwords are in the 16 byte hash form (eg: "mysqld --old-passwords &"). true?
Page 3 of 3 First 123
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo