Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Duplicate Website Question Question
Connect to DB installed into dedicated VPS (private networking) Question Question

Question

websites Error establishing a database connection

Posted November 30, 2020 427 views
MySQLWordPressMariaDBDatabases

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. “DBNAME”, “DBUSER”, “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 (‘WPALLOWREPAIR’, true); does not work

Add a comment
wallace11622
By:
wallace11622

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Duplicate Website Question Question
Connect to DB installed into dedicated VPS (private networking) Question Question

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.

×
Submit an Answer
2 answers
KFSys November 30, 2020

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

Reply Report
  • wallace11622 November 30, 2020

    Hello :)

    I get this error when I try to access my sites.
    https://ibb.co/ChjrtBb

    Wordpress does not connect to the database, why is that?
    I installed all my sites on my droplet, it has been 4 months on it.

    I did this test too, I tried to export my database from the website wkpmidia.com.br

    I used the command mysql -p -u nameuserdb namedb> wkpmidia.sql

    I received this error after pasting the password, I took the wp-config file.
    I got the information from the wkpmidia database via FTP.

    ERROR 1045 (28000): Access denied for user ‘wkpmidiacombr’ @ 'localhost’ (using password: YES)

    why access denied? all data is correct, username, database name, password …

    Reply Report
    • KFSys December 2, 2020

      Hi @wallace11622,

      Most probably your users do not have permissions for their databases. You can see the permissions of your users by entering MySQL on your droplet

      mysql

      and executing the following command inside

      SHOW GRANTS;

      It will show you which user has permissions on which database. To add permissions for your database user to a database, you can run the following again in mysql 

      GRANT ALL PRIVILEGES ON DatabaseName.*  TO 'DatabaseUser'@'localhost';

      Don’t forget to change DatabaseName with your true database name and DatabaseUser with your true database user.

      Regards,
      KFSys

      Reply Report
wallace11622 November 30, 2020
[deleted]
Reply Report

Related

Looking for something else?

Ask a new question Search for more help