WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Error establishing a database connection (1 post)

  1. Kartoony
    Member
    Posted 1 year ago #

    How to avoid the dreaded "Error establishing a database connection" when "cloning" a site to your local computer.

    I have a WP site hosted on inMotionHosting.

    I wanted to create a local copy on my computer to use for troubleshooting and generally messing around.

    I FTP-ed to my IMH site and downloaded all the files to a folder in the Sites directory of my iMac.

    I exported my SQL database to my Downloads folder.

    I had difficulty importing the data into phpMyAdmin. Seems as if the exported file wanted a specific database in which to import the data. (I guess that's pretty obvious, but sometimes I have difficulty with undocumented stuff like that.).

    Anyhow, I created a database with the same name as the database I created @ IMH. (I'm beginning to believe it MIGHT have been able to be named anything.) But once I did that and told the export file to use that database, the import worked like a champ.

    Great!

    Fire up the browser, type "localhost" in the URL window - (I have MAMP configured to point to a folder in which I have three website installations set up) - select the folder for my site and BAM - "Error connecting to database." RATS!

    DELETED wp-config file - figured I needed to recreate it.
    COPIED wp-config-sample to "root" folder (figured THAT out when I tried to recreate the wp-config file and was told that it needed the wp-config-sample file.)
    REFRESHED browser - continued creating wp-config
    ENTERED username and password information from the old wp-config file
    BAM - "Error connecting to database" - RATS!!
    CREATED a user in the database with same username and password as in the IMH site
    NO DEAL - didn't work
    Finally just used username = root and password = root (defaults when setting up DB) and...
    BAM - it worked.
    I was prompted to "Click to install", but terminated the operation since everything was already installed.

    Site is up and running just fine.

    Wondering what would happen if I deleted the user I created in the DB, I did so and the site still worked.

    Evidently you have to create a new database
    Import your data from the other site
    Delete wp-config to force the creation of the new wp config file (you probably can manually edit it, though).
    Make sure wp-config-sample is in the root directory
    Start up WP so it starts the creation of a new wp-config file
    Enter in the DB username and password information when prompted (if you are using defaults, then it's "root"/"root" - as in my example above)
    Stop the install process after you've connected to the DB

    Hope that helps someone else if you want to do the same thing I did.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.