wp-config and php database have different passwords

  • Hi,

    I have two WP databases on one server. One was my primary website. When I tried to update the PHP to be able to update WP the site no longer functioned. So I downloaded the current version of WP and manually uploaded it to the server. I got the credentials as outlined by my hosting agent, NetworkSolutions. I couldn’t get WP to connect to the database.

    So, I created a second database, with a different name and the new WP works perfectly. But I want my old WP back. I noticed in the new site, that works, the password, that works, is not the same as my password in the wp-config file. The one in the database is very long and doesn’t look anything like the one in the wp-config file. I must be looking in the wrong place. I go to the database and look in wp-users and the password is visible. I can also edit it. It is not the same as the wp-config password. Can anyone help? Thanks for any replies!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    The database password is not stored in the databae. Your UserID password is not used to access the database, and the value stored for it in the database is a one-way hash of the clear-text version.

    Try exporting the DB for your old site and importing it into the database to which you do have access via WP.

    Thread Starter kevin_freeman

    (@kevin_freeman)

    Thanks! I will give this a try. How is the password that appears in the config file generated? I don’t understand why Network Solutions says I can find the password in the database for the config file. They are clearly wrong.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    The password in wp-config.php (DB_PASS for DB_USER) is created by you when you create the user for your database (the one in DB_NAME on DB_HOST). If your host creates the database and user, then they provide you with that info.

    Thread Starter kevin_freeman

    (@kevin_freeman)

    Thanks for this info. What NetworkSolutions says, is that I must go into the database and change the password in the users file. I have not done this. And, I don’t see why when I replace the WP folder with the current version of WP that the config file doesn’t find the correct password. I was under the impression it would self populate that info. From my admin panel in NetworkSolutions I create a new database by “create new database.” I put in no username or password but do name the database. This creates a working database which I can then log into the WP admin pages and get on with my business. But I have never seen a password, through this process that looks like the password that I see when I open the config file. NetworkSolutions, like I say, cannot provide info other than change the password in the user file and use the same password in the config file. Thanks for your replies. I have been trying to link the new WP version to my database on and off with numerous calls to NetworkSolutins over the last 5 months to no avail. I should probably give up but had lots of stuff on the site and don’t want to loose it. I will try your idea of importing the unlinkabe database into the one that links. Thanks again!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wp-config and php database have different passwords’ is closed to new replies.