Error establishing a database connection in wordpress

I had this issue some days ago with a multisite, loading a live dump to local development. After some debugging I noticed, that the error message wasn’t right.
The database was connected, but the path in the database to the sites was wrong.
You can check table <your-prefix>_site and <your-prefix>_blogs if columns domain and path are correct.
That solved my problem, as the error message told something else.

Related Posts:

  1. What is this JavaScript “require”?
  2. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  3. Oracle SQL query for Date format
  4. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  5. Can I have multiple primary keys in a single table?
  6. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  7. get_results using wpdb
  8. wpdb->insert multiple record at once
  9. How to migrate a HTTPS WordPress installation to localhost?
  10. Database connection close
  11. How to monitor server for error establishing a database connection
  12. How to create bulk page and content? [closed]
  13. Importing posts from old website to new conflicting post ID’s?
  14. Connect to remote database using Localhost install
  15. remove missing image attachments
  16. Transient RSS feeds in wp_options not removed automatically?
  17. Best way to move live site local
  18. The revisions table in my database is at 70% capacity and growing. What should I do?
  19. WordPress for a very large website
  20. How to ensure data consistency in WordPress
  21. Database location in WordPress
  22. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  23. WP_list_table bulk_action get edit and delete
  24. How to display data from custom table in wordpress database?
  25. Change SQL get_results to search for posts with custom term in custom taxonomy
  26. How to diagnose and keep in check encoding issues?
  27. Add search Value to wp_list_table pagination
  28. stdObject stored in database. How does one convert it to usable format?
  29. I have a table I created, how do I make a form for a user to filter the data?
  30. What ALL can cause “Another update is currently in progress.”? [closed]
  31. Trigger Plugin database update after git pull
  32. wp_redirection_404 table has grown to 7GB
  33. Does WordPress ever need multiple databases?
  34. Why are no posts showing despite my apparently correct DB restoration?
  35. Cannot update custom database table row
  36. Change WordPress prefix for only one table?
  37. Two websites one database, administrator not working on second website
  38. Multiple wp_options tables to share content across installs
  39. Select two sums with single get_var statement
  40. How to get the SQL of the changes made to the database from an update or upgrade?
  41. Is there a smart way to obtain a list of only some selected user meta data?
  42. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  43. Permit Login if table row exists
  44. Make an Items attribute searchable (taxonomy using existing attribute)
  45. What would Repair and Optimize WordPress Database do?
  46. Store partial database to an archive database time to time
  47. Saving zero as meta value
  48. Migration: Copying database content to a different server
  49. Query multiple tables at once?
  50. Check if post id exist in table than only update instead of inserting new row
  51. Transferring/Uploading Data from DB to WordPress
  52. How to convert srcset links from https to http?
  53. How to get a list of WordPress default database tables?
  54. Changing order of db results when encoding to JSON
  55. How to transfer from localHost to live but use the already existing database on the server?
  56. Backing up WordPress database and files
  57. Creating and Using Tables in the WordPress Database
  58. How not to display ALL items of a database
  59. Connect a membership plugin to an external database
  60. How to get the records from start with A to G in php and mysql
  61. Storing user’s data on external database on other server
  62. Link multiple user databases together?
  63. is it right choose to connect database in template page directly in WordPress site?
  64. How to insert a value to decimal type field using wpdb->prepare?
  65. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  66. Set a cron job to delete a specific database table table every midnight
  67. Two separate wordpress installations at one domain
  68. Is there a way to edit the WP content database in an admin panel or external page?
  69. Can we store password in without being hashing?
  70. SQL database import #1046 error
  71. Get all top categories, then only 3 posts for each
  72. Having all “non-PHP” files on a different server
  73. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  74. error establishing database connection (WAMP + filezilla)
  75. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  76. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  77. How to optimize wp_option table?
  78. How do I update a WordPress wp_postmeta meta_value that contains many options
  79. How can I get $wpdb to show MySQL warnings?
  80. About wp database hooks (error establishing connection)
  81. Database for JQuery Autocomplete field
  82. Auto populate form fields based on serial input or pull listings from other websites?
  83. How to extract some part of WordPress full source code
  84. Create Tables in WordPress
  85. Error establishing a database connection for some files
  86. Hash user emails in database?
  87. WordPress Failed to Login (DB Error)
  88. Share WordPress Database
  89. DB access blocked when initializing WP externally
  90. Saving data to database and exporting to excel
  91. Site does not work right, pages not showing up, even for root admin
  92. ERROR: “Table Prefix” must not be empty
  93. How do you build a database-centric site in WP?
  94. One information repeated on multiple locations on one site [closed]
  95. WordPress: Interact with Database Query Data and Login
  96. Attach posts based on category and position
  97. Showing Error(TAble already exist)
  98. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  99. How can i change the nicename and the displayname in a bulk in the database?
  100. Have WordPress Use a Different Database for users
error code: 523