Not sure what's going on here 'cos I've done it already a couple of times and it always worked. Basically I'm moving a testing site from my local machine (MAMP) to a live server by:
- zipping the entire WP directory and uploading it to the server
- exporting db from localhost
- creating empty db on the server and importing the sql file
- updating wp-config file with the new credentials
When I try to access the site it gives me "Error establishing a database connection". I tripple checked the db details (db name, user, pass) and even log in via terminal using those credentials.
What am I doing wrong?