{"id":978,"date":"2025-05-14T09:19:36","date_gmt":"2025-05-14T07:19:36","guid":{"rendered":"https:\/\/mic.st\/blog\/?p=978"},"modified":"2025-05-21T13:25:48","modified_gmt":"2025-05-21T11:25:48","slug":"error-establishing-a-database-connection-and-how-to-fix-this","status":"publish","type":"post","link":"https:\/\/mic.st\/blog\/error-establishing-a-database-connection-and-how-to-fix-this\/","title":{"rendered":"Error establishing a database connection on WordPress Blog"},"content":{"rendered":"\n

I have to admit that I do not really regularily write into this blog. Usually, whenever I have an idea, I write down a first draft and finish the post later, sometimes weeks later. Some days ago I had such an idea and realized that the blog was completely unreachable. Not sure for how long actually. The only thing it showed was this error saying “Error establishing a database connection” (see image below).<\/p>\n\n\n

\n
\"Error
The error show when entering https:\/\/mic.st, saying “Error establishing a database connection”.<\/figcaption><\/figure>\n<\/div>\n\n\n

Update<\/strong>: If you are lucky, everything is a little easier to fix as described in my older article: https:\/\/mic.st\/blog\/how-to-fix-error-establishing-a-database-connection-for-wordpress\/<\/a><\/p>\n\n\n\n

Investigating the error<\/h2>\n\n\n\n

As nothing did work anymore from a frontend perspective, I quickly went into the webserver to find out what’s going on.<\/p>\n\n\n\n

First of all, it was years ago since setting up the wordpress website so I was not even aware which kind of database was actually supposed to run. After finding out that it’s “mariadb”, I just wanted to try restarting the database service. A quick Google search lead to this: https:\/\/mariadb.com\/docs\/server\/service-management\/operations\/start-stop-status\/<\/a><\/p>\n\n\n\n

Restarting can be done using:<\/p>\n\n\n

sudo systemctl restart mariadb<\/code><\/span><\/pre>\n\n\n
Unfortunately, this just did not work. It exited with following error:<\/p>\n\n\n
Job for<\/span> mariadb.service failed because the control process exited with error code.\nSee \"systemctl status mariadb.service\"<\/span> and \"journalctl -xe\"<\/span> for<\/span> details.<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
As mentioned in the error, running systemctl status mariadb.service<\/code> can give you a little more information about what did actually go wrong. As the error itself is not really giving you a lot.<\/p>\n\n\n\n
The error mentioned something regarding not enough space left. Which was a relieve as it sounded like I can just delete some files and everything should work again.<\/p>\n\n\n\n
I found out that the drive was actually pretty full. You might be able do that via your server panel (which I initally did) or you can run the following:<\/p>\n\n\n
df -h<\/code><\/span><\/pre>\n\n\n
The -h<\/code> argument does just mean “human readable”. You will get a nice output about your drives and space used which does give you a first indication of where you should free up some space. My main drive did show around of 99% space used, which obviously is a little too much. A little more about this command you can find here for example: https:\/\/opensource.com\/article\/18\/7\/how-check-free-disk-space-linux<\/a><\/p>\n\n\n\n
Where to save space?<\/h2>\n\n\n\n
To gain more insights on where to actually save space, it does make sense to have a look on the directories themselves. The command line tool ncdu<\/code> (see https:\/\/dev.yorhel.nl\/ncdu<\/a>) is of great use here as you quickly gain insights on where space is used. It is a fast and interactive tool. However, it is probably not installed by default with your Linux distribution. In my case I was not able to install it as that much space was taken by “whatever” (as I still did not know).<\/p>\n\n\n\n
Find space used without ncdu<\/h2>\n\n\n\n
Of course you can also find out about space used without ncdu<\/code>. For finding out about directories themselves, you can use du<\/code> or more specifically du -hs<\/code> to find out about the size of a given directory. It is using the one you are currently in if no path is passed.<\/p>\n\n\n\n
A good starting point is using:<\/p>\n\n\n
 du -h --max-depth=1 \/ | sort -h<\/code><\/span><\/pre>\n\n\n
It gives you the file size of anything located under \/<\/code> going down with a depth of one (as you do not want to the size of each and every directory on your filesystem). It is sorted so that you can easily spot the largest directory. Which in my case was var<\/code>.<\/p>\n\n\n\n
You can go down then directory by directory until finding out what is taking most space.<\/p>\n\n\n\n
Delete stuff<\/h2>\n\n\n\n
If you are not aware of what the stuff is you intend to delete: Google first! You can easily break your system by deleting the wrong things. Also consider doing a backup first via your webserver provider before deleting anything.<\/p>\n\n\n\n
Some ideas for stuff to delete:<\/p>\n\n\n\n