import - Error establishing a database connection; After importing DB & Theme

admin管理员组

文章数量:1022794

I'm doing some work on a client's wordpress so to not touch the live I imported what I thought I needed from their FTP into my xampp to reproduce their environment. Their website is hosted on bluehost, for reference.

I Exported/imported their phpmyadmin database, as well as copying over the parent theme and the child theme from FTP. I copied over the wp-config.php for database credentials. It seems like i'd have covered all the bases but it's giving me that error still. What else could I be missing to get this working?

DB_HOST is also already set to localhost

Googling this error didn't yield much for my scenario

Are there more things I should import over from their FTP to emulate 1:1 their environment?

Thanks

I'm doing some work on a client's wordpress so to not touch the live I imported what I thought I needed from their FTP into my xampp to reproduce their environment. Their website is hosted on bluehost, for reference.

I Exported/imported their phpmyadmin database, as well as copying over the parent theme and the child theme from FTP. I copied over the wp-config.php for database credentials. It seems like i'd have covered all the bases but it's giving me that error still. What else could I be missing to get this working?

DB_HOST is also already set to localhost

Googling this error didn't yield much for my scenario

Are there more things I should import over from their FTP to emulate 1:1 their environment?

Thanks

• database
• import

Share Improve this question asked Apr 23, 2019 at 2:24 DennisioDennisio 1511 silver badge55 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 1

The database password is not stored in the database itself, so importing the database via phpmyadmin will not also import the password. You need to manually edit your local copy of wp-config.php, and enter your local username and password for MySQL ( or any other database you are using ).

Usually the default username for local development installations is root, and the password is blank, so you can try these. Otherwise, you can check xampp's website to see what the default password, or if you have already set your own password during installation, you can use that.

If you need to move more sites in the future, Duplicator plugin is nice and easy.

It will create two files, an archive and a install file. Upload the files to your server, create the database and user, run the installer file and it will guide you through the process. Everything will be copied over and it will allow you to update the site links and all the database connections.

The only catch is that it can timeout on very large sites.

I'm doing some work on a client's wordpress so to not touch the live I imported what I thought I needed from their FTP into my xampp to reproduce their environment. Their website is hosted on bluehost, for reference.

I Exported/imported their phpmyadmin database, as well as copying over the parent theme and the child theme from FTP. I copied over the wp-config.php for database credentials. It seems like i'd have covered all the bases but it's giving me that error still. What else could I be missing to get this working?

DB_HOST is also already set to localhost

Googling this error didn't yield much for my scenario

Are there more things I should import over from their FTP to emulate 1:1 their environment?

Thanks

I'm doing some work on a client's wordpress so to not touch the live I imported what I thought I needed from their FTP into my xampp to reproduce their environment. Their website is hosted on bluehost, for reference.

I Exported/imported their phpmyadmin database, as well as copying over the parent theme and the child theme from FTP. I copied over the wp-config.php for database credentials. It seems like i'd have covered all the bases but it's giving me that error still. What else could I be missing to get this working?

DB_HOST is also already set to localhost

Googling this error didn't yield much for my scenario

Are there more things I should import over from their FTP to emulate 1:1 their environment?

Thanks

• database
• import

Share Improve this question asked Apr 23, 2019 at 2:24 DennisioDennisio 1511 silver badge55 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 1

The database password is not stored in the database itself, so importing the database via phpmyadmin will not also import the password. You need to manually edit your local copy of wp-config.php, and enter your local username and password for MySQL ( or any other database you are using ).

Usually the default username for local development installations is root, and the password is blank, so you can try these. Otherwise, you can check xampp's website to see what the default password, or if you have already set your own password during installation, you can use that.

If you need to move more sites in the future, Duplicator plugin is nice and easy.

It will create two files, an archive and a install file. Upload the files to your server, create the database and user, run the installer file and it will guide you through the process. Everything will be copied over and it will allow you to update the site links and all the database connections.

The only catch is that it can timeout on very large sites.

本文标签： importError establishing a database connection After importing DB amp Theme