Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    96

    Unanswered: Move DB from one server to another with the same encrypted passwords

    Hello,
    I am moving a site from one host to another. I have a list of members in a table which have an encrypted password (using the PASSWORD() encryption method).
    Could any one tell me how to transfer the settings form one DB to another in order to keep the passwords the same?
    I will be using the export functionality from PhpMyAdmin to transfer the tables and content across.

    Many thanks
    Olivier

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    If you are running the same version, you shouldn't have to do anything, they should be the same.

    More importantly you should NOT be using PASSWORD() to encrypt user passwords. The algorithm changes from mysql version to version. MySQL specifies in the manual it should not be used for the purposes you are using it, but only creating user privileges to mysql itself.

    Also note it is not as strong encryption as SHA1 which is most likely the algorithm you should be using to hash your passwords.

Posting Permissions

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