Application Cannot Connect to Database

What causes an application cannot connect to database error?

There are several things that could cause an application cannot connect to database error. It means for some reason, the PHP code isn’t able to retrieve information from the database where everything is stored. You may be using the wrong database name, the wrong username/password, the wrong database host or the database may have even become corrupt. This error typically manifests itself by displaying “ERROR  ESTABLISHING DATABASE CONNECTION” when visiting the site in question.

 

How to fix application cannot connect to database error

If you’re getting the application cannot connect to Database error, try these steps:

 

  • Make sure you’re adding your MySQL username before the database name (username_databasename)
  • Make sure you’re using the correct database host, if your database is hosted on the same server as the site this will be localhost
  • Make sure you’re using the right database, username and password

 

If you’ren’t sure if you’re using the right username and password, you can create a fresh username and password using MySQL® Databases in your cPanel. Under “Add New User”, set a username and password and click “Create User”.

 

Showing where to add users in the Add New User box in MySQL Users

 

Now you need to assign the new user you just created to the right database. Go to “Add User to Database” to do so.

 

Showing where to add new users to a MySQL database

 

Important: You’ll need to change your wp-config file to use the new username and password, too.

 

How do I repair a corrupt WordPress database?

If you suspect your database may be corrupt, you can try to repair it with the built-in repair function in WordPress.

 

  1. Go to the File Manager in cPanelShowing where to locate File Manager in cPanel
  2. Find your wp-config file.
  3. Add this just above the line that starts with “That’s All, Stop Editing”:
  4. Visit http://www.yourdomain.com/wp-admin/maint/repair.php
  5. You should see a page with options to repair or repair and optimize
  6. Visit http://www.yourdomain.com/wp-admin/maint/repair.php
  7. You should see a page with options to repair or repair and optimize

Important: This page is not secure and can be accessed by anyone. If you go this route, make sure you remove that line from the wp-config file when you’re done.


Share:

Leave a Reply