Support » Fixing WordPress » incorrect MySQL database credentials

  • Ive been locked out after GoDaddy reported this:
    “showing “Error establishing a database connection”, seems your wp-config.php file contains incorrect MySQL database credentials, please update those with correct one, that should get site up and running.”

    I can’t enter my site: Error establishing a database connection

    I don’t know how to fix it.

    The page I need help with: [log in to see the link]

Viewing 15 replies - 1 through 15 (of 17 total)
  • Hi,

    The error you’re seeing means WordPress cannot connect to the database, because the credentials in the wp-config.php are incorrect.

    So I can provide you better help, could you please confirm whether you’re using GoDadddy’s Managed WordPress or if this is a custom WordPress you installed on a GoDaddy server.

    Thanks in advance for your clarifications.

    lisa

    (@contentiskey)

    Thread Starter israelandstuff

    (@israelandstuff)

    Hi Lisa,

    Thanks for the link. Unfortunately, my expertise in doing as it explains is too inadequate to even understand whats required.

    Is there someone who can fix this? I still can’t even access my account.

    Thanks!

    Phillip

    Thread Starter israelandstuff

    (@israelandstuff)

    Hi Paulo,

    Honestly I don’t know which. If one is a paid for service, then I don’t think I have that. I believe it was a free download to build my site.

    Since I’m unable to repair this on my own, what will it entail/cost to acquire the service of making my site accessible?

    Thanks so much,
    Phillip

    Hi Phillip,

    Thank you for providing further information. If you’re not using GoDaddy’s Managed WordPress offering, then you (or someone on your behalf) must have installed WordPress on a GoDaddy server.

    In your opening post you said “GoDaddy reported this”. Could you clarify where you saw that error message? Was it an email you received from GoDaddy? Did you see it on the GoDaddy control panel? Or did you just see that error when visiting your site at http://Israelandstuff.com?

    Could you please also confirm whether your site used to work and is now broken, or if it never worked?

    Finally, was this a site you built and put online yourself or did you hire someone to build it and put it online?

    This information will helps us help you 🙂

    Thanks,
    Paulo

    Thread Starter israelandstuff

    (@israelandstuff)

    1)
    This is the email I received:

    Sucuri Web integrity monitor alert.
    Warning for site: http://israelandstuff.com
    Details: 
    
       *Security warning in the URL: http://israelandstuff.com/
        Site error detected. Details: http://labs.sucuri.net/db/malware/warning.500_internal_error?1
       *Security warning in the URL: http://israelandstuff.com/404testpage4525d2fdc
        Site error detected. Details: http://labs.sucuri.net/db/malware/warning.500_internal_error?1
       *Security warning in the URL: http://israelandstuff.com/404javascript.js
        Site error detected. Details: http://labs.sucuri.net/db/malware/warning.500_internal_error?1
       *Security warning in the URL (for Google's UA): http://israelandstuff.com
        Site error detected. Details: http://labs.sucuri.net/db/malware/warning.500_internal_error?1
    
    Submit a Malware Removal Request
    https://supportx.sucuri.net/support/?new&mremoval
    
    This message was generated automatically.
    
    GoDaddy Inc.

    —————————————————————–
    After receiving the email, I went to my site and saw this message:

    Can’t select database
    We were able to connect to the database server (which means your username and password is okay) but not able to select the i6948661_wp1 database.
    
    Are you sure it exists?
    Does the user gdtestconn have permission to use the i6948661_wp1 database?
    On some systems the name of your database is prefixed with your username, so it would be like username_i6948661_wp1. Could that be the problem?
    If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.
    Thread Starter israelandstuff

    (@israelandstuff)

    2) Up until I checked the site, it worked fine. I did have a problem once before and GoDaddy online live support fixed it in about 30 minutes. That was a while back.

    3) I bought the site and followed a YouTube tutorial to build it. It recommended WordPress, so I downloaded it. Since so many plugins were free and many I purchased, I can’t recall which one did with wordPress.

    Thanks again!

    Philliip

    Thread Starter israelandstuff

    (@israelandstuff)

    oh… the site is about 10 years online….if that means anything. I do update plugins etc whenever needed. I believed my WordPress was also the latest version.

    Phillip

    I think you should try contacting GoDaddy’s support, since this might be an issue on their end, assuming you haven’t changed the database credentials recently.

    Do let us know if GoDaddy’s support is able to resolve the issue, if you please.

    Best,
    Paulo

    Thread Starter israelandstuff

    (@israelandstuff)

    They were the ones who sent me to you. This was their message:

    've just finished working on your website and everything is looking clean, no malware inside. 
    
    Domain is currently showing "Error establishing a database connection", seems your wp-config.php file contains incorrect MySQL database credentials, please update those with correct one, that should get site up and running. 
    
    Please be sure to read and follow our post-cleanup instructions here:  
    
    - Update your website!
    
    If you are using WordPress, Joomla (or any other CMS), and it is not already using the stable current version, take a minute to update please. Why? Because out-of-date software is the leading cause of infections. This includes your CMS version, plugins, themes, and any other extension type.
    
    - Change your password for all access points. This includes FTP, SFTP (or SSH), CPANEL, etc… .
    
    Choose a good and strong password. What often defines a good password is built around three core components – Complex, Long, and Unique. The argument most make when it comes to passwords, is that it’s too difficult to remember multiple ones. This is true. It’s also why Password Managers were created.
    
    *Password Tip: Start using a password manager like: Peguta or LastPass. They're online and free.
    
    - Change your database password.
    
    If you are using a CMS (WordPress, Joomla, etc…) change your database password. Please be sure to update your configuration file – Joomla: configuration.php and WordPress: wp-config.php. This is not an automated process so you will need to know how to open those files and edit manually. If you’re not familiar with handling changes in your database and configuration files, contact your host.
    
    - Run a virus scan on your personal desktop/laptop.
    
    In a lot of cases we see that websites are compromised via local environments (notebooks, desktops, etc.). It's why we always ask you take a minute to run an antivirus product. If you’re okay with spending a little money, BitDefender is leading the pack in malware detection on MAC’s and PC’s. Other alternatives includes Kaspersky for Windows and MAC, and Sophos and F-Secure for Windows. You can also try Avast, MSE, Spybot that are free alternatives and very good. Here is the bottom line - it doesn’t matter how many times your site gets cleared, if your desktop is not clean, your site can get reinfected quite easily.
    
    If you need anything else don't hesitate to contact us.
    
    We are glad to see you with us, thank you for using our service!
    Thread Starter israelandstuff

    (@israelandstuff)

    Paulo,

    If this is indeed a problem associated with WordPress, I really hope you can assist me. This is a problem way beyond my abilities.

    Than you,
    Phillip

    Thread Starter israelandstuff

    (@israelandstuff)

    Hey Paulo

    What about my last two comments?

    Hi Phillip,

    I apologize for the delay in replying to you.

    In one of your previous posts you mentioned you had seen this message on your site (I had previously not seen this reply from you):

    Can’t select database
    We were able to connect to the database server (which means your username and password is okay) but not able to select the i6948661_wp1 database.

    This confirms that the database credentials in the wp-config.php are incorrect, which causes WordPress to not be able to connect to the database.

    As lisa posted above, GoDaddy has specific instructions to resolve this issue in this page:

    https://www.godaddy.com/help/update-wordpress-database-connection-string-26356

    By following the instructions on that page you should be able to resolve the issue. Please do let us know if you were able to resolve the issue by following those instructions.

    Best regards,
    Paulo

    Thread Starter israelandstuff

    (@israelandstuff)

    Hi Paulo,

    Thanks for getting back. I was afraid that you guys simply gave up.

    OK… Yes, I say the notice from Lisa, went to the link and sent her this message:

    Hi Lisa,
    
    Thanks for the link. Unfortunately, my expertise in doing as it explains is too inadequate to even understand whats required.
    
    Is there someone who can fix this? I still can’t even access my account.
    
    Thanks!
    
    Phillip

    In short: I have no idea how to do any of the things required…. so I need you guys.

    Thanks,

    Phillip

    Hi Phillip,

    Since this isn’t a WordPress issue, and fixing it requires having access to the database user and password, which is sensitive information, I’m afraid we won’t be able to fix it through this forum.

    If you aren’t able to follow GoDaddy’s instructions to fix this issue, I think you should contact GoDaddy’s support.

    Alternatively, you could consider hiring someone so that you can give them direct access to the site. Please try https://jobs.wordpress.net/ or https://jetpack.pro/ and do not accept any hire offers posted to these forums.

    I understand this might not be the answer you were hoping for, but I’m afraid that’s the best help we can provide you.

    Thank you and regards,
    Paulo

Viewing 15 replies - 1 through 15 (of 17 total)
  • You must be logged in to reply to this topic.