{"id":9188,"date":"2017-11-08T15:13:18","date_gmt":"2017-11-08T20:13:18","guid":{"rendered":"https:\/\/www.boldgrid.com\/support\/?p=9188"},"modified":"2020-03-12T14:39:23","modified_gmt":"2020-03-12T18:39:23","slug":"troubleshooting-error-establishing-database-connection","status":"publish","type":"post","link":"https:\/\/www.boldgrid.com\/support\/troubleshooting\/troubleshooting-error-establishing-database-connection\/","title":{"rendered":"Troubleshooting “Error Establishing Database Connection”"},"content":{"rendered":"\n

Getting the “Error Establishing Database Connection”<\/strong> page can be a frustrating experience. In most cases, this means your website files are not able to connect to the MySQL service, or the service is not running. The following article will explain how you can troubleshoot these types of MySQL<\/b> issues.<\/p>\n

 <\/p>\n

\"\"<\/a>
\nThere are three common reasons that can cause the message “Error Establishing Database Connection” to occur on your website. <\/p>\n

    \n
  1. The login credentials in the configuration are not correct, <\/li>\n
  2. the MySQL server is not running, or <\/li>\n
  3. he database is corrupted, and in need of repair. <\/li>\n<\/ol>\n

    The following article will outline instructions on checking all three.<\/p>\n

    Checking the MySQL login credentials<\/h2>\n

    If you have recently made any changes to the configuration, or installed WordPress, you can check the wp-config.php file to ensure the credentials match what MySQL expects. The credentials you would need to accomplish this are the host, the database username, the database users password, and the database name itself. <\/p>\n

    If you are not familiar with editing your files, then it would be recommended to contact your host, as they should have the information needed to help you with this step.<\/div>\n

    \"\"<\/a>
    \nIn this example, the credentials needed would be the following:
    \nDatabase Name: database_name
    \nDatabase Username: database_username
    \nPassword: database_password
    \nHost: localhost<\/p>\n

     
    \nThe easiest way to verify these credentials is to navigate to your hosts MySQL interface, and it should list the database with the attached user, as well as have a place to set the password. If you are not able to view the current password, you would want to set it to what is found within your wp-config.php file, to ensure that the credentials match.<\/p>\n

    Checking the MySQL server<\/h2>\n

    If you have checked your MySQL credentials, and the problem persists, there may be an issue with your MySQL server. To check the status, you can use telnet to view the status of the service. The simplest way to do so would be running the following command:
    \ntelnet yourdomain.com 3306<\/code>
    \nIf MySQL is running, this should return output similar to the following:
    \n    \"\"<\/a>
    \nIf it is not running, the Connection will be refused
    \ntelnet: connect to address IP ADDRESS: Connection refused<\/p>\n

    Repairing your Database<\/h2>\n

    The third most common reason for the “Error Establishing a Database Connection” is a corrupt database, which can be caused by a number of things. Some of the reasons include a server crash, or hardware failure as well as processed being killed while writing to the database. These crashes also depend whether you are using MyISAM or InnoDB, as MyISAM is more susceptible to corruption. <\/p>\n

     <\/p>\n

    To correct this, you can simply add this line to your wp-config.php file:
    \ndefine( 'WP_ALLOW_REPAIR', true );<\/code>
    \nOnce you have added this, you can reload your website, and should see this message when visiting \/wp-admin\/
    \n    \"\"<\/a>
    \nIf editing your files is not something you wish to do, the following guide will show you how to repair your database within phpMyAdmin.<\/p>\n

    Repairing a database in phpMyAdmin<\/h2>\n
      \n
    1. Login to phpMyAdmin\n
      <\/div>\n<\/li>\n
    2. \"\"<\/a>Choose the database you are working with by clicking on it in the left menu\n
      <\/div>\n<\/li>\n
    3. \"\"<\/a>Underneath the database, select Check All to highlight all the tables above\n
      <\/div>\n<\/li>\n
    4. \"\"<\/a>Using the menu on the right hand side of the Check All option, select Repair Table\n
      <\/div>\n<\/li>\n
    5. \"\"<\/a>Upon completion, you will see the Success Message\n
      <\/div>\n<\/li>\n<\/ol>\n

       <\/p>\n

      Congratulations! Now you are familiar with troubleshooting the most common causes of the “Error Establishing Database Connection”<\/strong> message. If you are still receiving the error after attempting these steps, then it would be recommended to contact your host for further assistance.<\/p>\n<\/body><\/html>\n","protected":false},"excerpt":{"rendered":"

      Getting the “Error Establishing Database Connection” page can be a frustrating experience. In most cases, this means your website files are not able to connect to the MySQL service, or the service is not running. The following article will explain how you can troubleshoot these types of MySQL issues.   There are three common reasons […]<\/p>\n","protected":false},"author":529,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"bgseo_title":"Troubleshooting \"Error Establishing Database Connection\"","bgseo_description":"The following article explains how you can troubleshoot MySQL issues such as \"Error Establishing Database Connection\" with BoldGrid, phpMyAdmin and telnet. ","bgseo_robots_index":"index","bgseo_robots_follow":"follow","footnotes":""},"categories":[74],"tags":[],"class_list":["post-9188","post","type-post","status-publish","format-standard","hentry","category-troubleshooting"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/posts\/9188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/users\/529"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/comments?post=9188"}],"version-history":[{"count":13,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/posts\/9188\/revisions"}],"predecessor-version":[{"id":9704,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/posts\/9188\/revisions\/9704"}],"wp:attachment":[{"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/media?parent=9188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/categories?post=9188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/tags?post=9188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}