![\"Error](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/05\/FehlerbeimAufbaueinerDatenbankverbindung.png\")
<\/figure>\n\n\n\nSo don't worry:<\/strong> This step-by-step guide will show you how to fix the \"Error establishing a database connection\" error.<\/p>\n\n\n\n To test the various proposed solutions for your website, you need: <\/p>\n\n\n\n In the following, we will go into the solutions to the various causes of the error message. In the vast majority of cases, it is due to incorrect database user data in wp-config.php. Let's start with that right now!<\/p>\n\n\n\n Note \ud83d\udca1:<\/b> Before you start with the various troubleshooting options, we recommend that you carry out a Backup your WordPress website<\/a> to create. <\/p>\n\n\n\n As WordPress hoster<\/a> we regularly support our customers in resolving the error \"Error when establishing a database connection\". In 98 % of the support cases, the website operators receive the error message due to incorrect database user data in wp-config.php.<\/p>\n\n\n\n The \"wp-config.php\" file is a standard file that is present in every root directory of a WordPress instance. <\/p>\n\n\n\n In \"wp-config.php you will find four database details that must match the database used. If one of the four entries does not match, the white screen of death will be displayed on your website. <\/p>\n\n\n\n 1. database name<\/strong><\/p>\n\n\n\n 2. database user name<\/strong><\/p>\n\n\n\n 3. database password<\/strong><\/p>\n\n\n\n 4. host name of your database<\/strong><\/p>\n\n\n\n In summary, the details of the database that the wp-config.php wants to access look something like this: <\/p>\n\n\n\n To check the user data for correctness, you need access to:<\/p>\n\n\n\n Note \ud83d\udca1:<\/b> <\/strong>We'll show you how to customize the database user data in your hosting interface at WPspace. You don't need FTP access to do this.<\/p>\n\n\n\n The first step is to copy the database data from wp-config.php so that you can compare it with the \"real data\" afterwards.<\/p>\n\n\n\n Log in to the WordPress hosting of your website and navigate to \"Files\" via the left menu. You are now in the base directory of your website. <\/p>\n\n\n\n By default, you will now select the \"httpdocs\" folder. There you will already find the necessary file \"wp-config.php\".<\/p>\n\n\n\n Click on wp-config.php to open it. There you will find the \"Database settings\". Make sure you save the complete section on the database settings in a Word document or similar.<\/p>\n\n\n\n After you have successfully copied the data from wp-config.php, the first step is to compare the name and user of the database.<\/p>\n\n\n\n To do this, navigate to the menu item \"Databases\". If you have several databases here, scroll to the database with the name (DB_NAME) specified in wp-config.php.<\/p>\n\n\n\n Now compare the DB_NAME and the DB_User with the information in the database. This is the cause in most cases.<\/p>\n\n\n\n \u2705 If these match, you do not need to adjust the DB_NAME and DB_USER in wp-config.php<\/p>\n\n\n\n \u274c If these do not match, this is the cause of the error on your website<\/strong> Next, we check the password and the host of the database. To do this, we navigate to the user administration in the \"Databases\" menu item.<\/p>\n\n\n\n There you will find an overview of all database users available in your hosting plan. Find the appropriate user again based on the information in wp-config.php. Click on the user.<\/p>\n\n\n\n The database server is specified in wp-config.php under 'DB_HOST'. <\/p>\n\n\n\n Copy the password from the copied data and enter it here in the database user mask. Confirm with the \"Ok\" button.<\/p>\n\n\n\n \u2705 If the DB_HOST in wp-config.php matches, no changes need to be made.<\/p>\n\n\n\n \u274c If the DB_HOST does not match, this is the cause of the error on your website<\/strong> Note \ud83d\udca1:<\/b> This step is only necessary if the data in the database user and the wp-config.php do not match.<\/p>\n\n\n\n Navigate back to your httpdocs folder via \"Files\". Open the wp-config here. <\/p>\n\n\n\n Now replace the incorrect data with the correct data from the database and confirm with \"Save\".<\/p>\n\n\n\n After you have made the adjustment in wp-config.php, you should be able to access your website normally again. If the error persists, I recommend that you test the next recommended methods!<\/p>\n\n\n\n Have you just noticed during testing that your database no longer exists? Then this is one reason for the error when calling up your website.<\/p>\n\n\n\n Without the database, WordPress cannot access any data. And therefore cannot display any data. <\/p>\n\n\n\n To fix the error, I recommend that you restore a backup of your database. Have you not created your own backups? Then check whether your host regularly creates backups for you.<\/p>\n\n\n\n WPspace creates daily backups of your website, which are available to you for 14 days. Simply select the most recent backup and restore it. If there is still no database, select the next older backup from the overview and continue in this way.<\/p>\n\n\n\n It is very unlikely that your database or the table it contains is damaged. However, this can happen in rare exceptional cases. <\/p>\n\n\n\n A connection to your database is established when your website is called up. An error occurs when trying to read and export the tables\/data from the database. As a result, your website cannot be displayed. <\/p>\n\n\n\n If you have experienced this rare case, you have the following three options for repairing your database.<\/p>\n\n\n\n As WPspace and therefore Managed WordPress hosting<\/a> As a WPspace customer, the \"Check and repair database\" function is available natively in the hosting interface. This tool saves you complicated detours and you can also check in the first step whether there is a damaged database at all. It's that easy to check and repair your database:<\/p>\n\n\n\n \u2705 Do you receive a Success message \"Database has no errors\"<\/strong> your database is not damaged. You therefore do not need to repair the database. A damaged database is not the cause of the error message \"Error establishing a database connection\".<\/p>\n\n\n\n \u274c Do you receive No success message<\/strong>your database is damaged. The native function will then automatically repair your database for you. <\/p>\n\n\n\n If the \"Repair database\" function is not natively available in your hosting, you can also carry out the steps via phpMyAdmin. How to repair your website's database via phpMyAdmin:<\/p>\n\n\n\n Alternatively, you can also repair your database via WordPress. In my opinion, this is the most complex way. With the following instructions, you can also do this without any problems: <\/p>\n\n\n\n 1. access your main directory: 2. open the wp-config.php Note \ud83d\udca1:<\/b> Depending on the host, it may be necessary to download wp-config.php and upload it again after customization. You can then save the TXT file locally on your PC using programs such as Notepad++<\/a> (recommendation) or Sublime Text <\/a>edit.<\/p>\n\n\n\n 3. add a line of code<\/strong><\/p>\n\n\n\n Enter the following line of code in wp-config.php:<\/p>\n\n\n\n 4. call up the WordPress database repair page<\/strong> In summary, the link looks something like this: <\/p>\n\n\n\n Important: <\/strong>Exchange deinedomain.de with your actual own domain.<\/p>\n\n\n\n 5. repair database<\/strong> 6. remove code line 7. check website There are factors over which you generally have no direct influence. These include the accessibility of your host's database server.<\/p>\n\n\n\n If you are looking for a Reliable WordPress hosters like WPspace<\/a> this usually happens very rarely or not at all. WPspace had an annual average availability of 99.9 % in 2024! \ud83d\ude80<\/p>\n\n\n\n However, if you suspect that your hosting's database server is the cause of the error message, you have various options for determining the accessibility of the database server.<\/p>\n\n\n\n Note \ud83d\udca1:<\/b> The database server may be unavailable and the \"main server\" that runs your hosting is available. <\/p>\n\n\n\n I recommend that you only import a backup if the cause is still unknown to you and you have no other solution. The following tips and information on importing the backup: <\/p>\n\n\n\n\n
Incorrect database user data stored in wp-config.php<\/h2>\n\n\n\n
![\"Database](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/Datenbankname.png\")
<\/figure>\n\n\n\n![\"Database](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/Datenbankusername.png\")
<\/figure>\n\n\n\n![\"Database](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/Datenbankpasswort.png\")
<\/figure>\n\n\n\n![\"Database](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/Datenbankhostname.png\")
<\/figure>\n\n\n\n![\"Database](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/Datenbankangabenwpconfig.png\")
<\/figure>\n\n\n\nInstructions: Check and adjust the user data<\/h3>\n\n\n\n
\n
1. check the database details in wp-config.php<\/h4>\n\n\n\n
![\"Website](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/image-1024x541.png\")
<\/figure>\n\n\n\n![\"Database](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/DatabaseAngaben.png\")
<\/figure>\n\n\n\n2. check names and users of the database<\/h4>\n\n\n\n
![\"Compare](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/DatenbankUserundName.png\")
<\/figure>\n\n\n\n
Then copy the name and user of the database that belongs to your website in your hosting interface into your Word document.<\/p>\n\n\n\n3. check the database password<\/h4>\n\n\n\n
![\"Database](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/DatenbankBenutzerverwaltung-1024x253.png\")
<\/figure>\n\n\n\n![\"Check](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/04\/DatenbankdatenPruefen.png\")
<\/figure>\n\n\n\n
Copy the DB_HOST into your Word document so that you can adjust it immediately in wp-config.php. <\/p>\n\n\n\n4. adjust data in the wp-config.php<\/h4>\n\n\n\n
5. test website<\/h4>\n\n\n\n
Deleted database<\/h2>\n\n\n\n
Repairing a damaged database <\/h2>\n\n\n\n
Repair database via the hosting interface<\/h3>\n\n\n\n
\n
![\"Check](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/05\/Ueberpruefenundreparieren.png\")
<\/figure>\n\n\n\nRepair database via phpMyAdmin<\/h3>\n\n\n\n
![\"Repair](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/05\/DatenbankreparierenPHP-1024x797.png\")
<\/figure>\n\n\n\n\n
Repair database via WordPress<\/h3>\n\n\n\n
<\/strong>Access the main directory of your WordPress website either directly via your hosting interface or via FTP access <\/p>\n\n\n\n
<\/strong>In the root directory \/ main directory of your websites you will find the file \"wp-config.php\". Open this file.<\/p>\n\n\n\ndefine('WP_ALLOW_REPAIR', true);<\/code><\/pre>\n\n\n\n
You can call up the repair page for the WordPress database with the following prefix: \/wp-admin\/maint\/repair.php<\/p>\n\n\n\nhttps:\/\/deinedomain.de\/wp-admin\/maint\/repair.php<\/code><\/pre>\n\n\n\n
After you have clicked on the link, the WordPress repair page will appear. Here you click on the \"Repair database\" button. WordPress will now automatically repair your database for you.<\/p>\n\n\n\n![\"\"](\"https:\/\/wp-space.de\/wp-content\/uploads\/2024\/05\/DatenbankreparierenWordPress.png\")
<\/figure>\n\n\n\n
<\/strong>Navigate back to your wp-config.php. Search here for your added line (the easiest way to do this is to use CTRL+F and insert \"define('WP_ALLOW_REPAIR', true);\"). Delete the line from the file and save the updated wp-config.php.<\/p>\n\n\n\n
<\/strong>Call up your website in the Incognito tab and check whether the error \"Error establishing a database connection\" has been fixed.<\/p>\n\n\n\nCheck the accessibility of your database server<\/h2>\n\n\n\n
\n
A status page is used to keep customers up to date on current outages, restrictions and maintenance work. A professional hoster always keeps this overview up to date.
You can find all information about the status at WPspace via this link: WPspace Status (statuspage.io)<\/a>
Tip: <\/strong>It is often possible to be automatically informed of updates by e-mail. <\/li>\n\n\n\n
<\/strong>If you do not know the link to the hoster's status page, you can also contact the hoster's support team directly by phone, email or via support chat. <\/li>\n\n\n\n
<\/strong>Try to access the database directly via your hosting interface or alternatively via phpMyAdmin. Can't access the database? Then it may be that the database server is not accessible.<\/li>\n\n\n\n
Do you have a second page on the same server? Then try calling it up. If the website also shows you the error \"Error establishing a database connection\", this confirms the assumption that the database server is not accessible.<\/li>\n<\/ul>\n\n\n\nImport current backup<\/h2>\n\n\n\n