I am teaching myself to manually restore a WordPress Database using MySQL Workstation. This Database is coming from a Production instance in AWS EC2 (Amazon Linux with Maria DB) to a localhost (which is already up and running).
I can successfully export that database and run it locally, but when I run it in a browser I get “Error Establishing Database Connection”.
Using the wp-config.php file, I changed the entries DB\_NAME, DB\_USER and DB\_PASSWORD
*What am I missing for a manual restore?*
Ultimately I’d like to find a system that is both a backup & allows me to run local instances as a sort of “source control”.
Thanks in advance for the sanity check!
[ad_2]
That error means you have incorrect db connection values.
What is your local set up? Is your DB_HOST value correct?