Question
websites Error establishing a database connection
- Posted on November 30, 2020
- MySQLWordPressMariaDBDatabases
Asked by wallace11622
Hello! I already followed all the help tutorials from digitalocean and I was unable to put my websites online again.
My website wkpmidia.com.br (totally offline) receives “Error establishing a database connection”.
dietasbaratas.com (some pages accessible, but / wp-admin receives the message “Error establishing a database connection”).
oticahorus.com.br (some pages accessible, but / wp-admin receives the message “Error establishing a database connection”).
I used FTP to get data from each wordpress site in wp-config. “DB_NAME”, “DB_USER”, “DB_PASSWORD”.
I tried to connect via MYSQL via SSH, but I get the error “acess denied” how can i get denied access? I got the information for each database in the wp-config file.
I’ve already followed the tutorials and nothing has resolved, not even adding define (‘WP_ALLOW_REPAIR’, true); does not work
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
This comment has been deleted
Hi @wallace11622,
It seems your WordPress is unable to connect to your database. Firstly, can you confirm if you host your Database on your Droplet on or an external source? If it’s on your droplet you’ll need to check your username and if it has access, if it’s on an external source, you’ll need to make sure your Droplet IP has access.
The next problem you mentioned is being unable to login to either MySQL or via SSH. You can resolve this by going to your WebConsole for your droplet, in your Control Panel. From there you should be able to reset your password as well and gain access.
Looking forward to your reply regards the first part of the answer!
Regards, KFSys