Error establishing a database connection
-
I’m getting an error connecting to the database when trying to access a new site that I have set up. I have an existing server and wanted to create a test box so I can test out any plugins/updates etc before pushing to live.
The steps I went through are below:
Restored the EC2 instance hosting a bitnami wordpress multisite stack to a new EC2 instance
Ran mysqldump to dump out the production database to a file from the old EC2 server
Span up a new RDS instance (the production database is also on an RDS instance)
Restored the wordpress database from the dump file to this new RDS instance.
SSH into the new EC2 server
Changed the /opt/bitnami/apps/wordpress/htdocs/wp-config.php with the new connection details (URL, user & password)
Added a new user with full rights to the new test database
Changed the relevant security groups in AWS for the new EC2 and RDS instance
Verified I can connect from the new EC2 instance to the wordpress database on the new mysql RDS instance with the connection details in the wp-config file via a shell session
Ran /opt/bitnami/ctlscript.sh restart to restart the services.
When I go to the new URL I get a “Error establishing a database connection” message.Any ideas?
The page I need help with: [log in to see the link]
-
Hi thanks for the link.
I’ve checked the config and I have used the same details that are in the wp-config file to connect directly to the RDS wordpress database and run a query, so I don’t think it is that.
Are there any changes I need to make in the wordpress database tables if I change the domain name when connecting to the new server with the new domain name? i.e. will it have a database connection issue?
I’d assumed I’d be able to connect to wordpress but would have to make some configuration changes once in, rather than have a database error.
Thanks.
- The topic ‘Error establishing a database connection’ is closed to new replies.