How to fix 'Error establishing a database connection' | WP Learning Lab

Error establishing database connection is a very common error that I bet every WordPress user has encountered at some point. Luckily the fix is very easy and there are two ways to fix it.

Let's tackle the first one first.

If you're not sure where to find the ones you created, log into your cPanel account.

While you're here, you can make sure that the second possible reason for the error is taken care of.

At the bottom of the MySQL database page you will be able to link the database user to the database. Make sure they are linked and the correct privileges are set. If you're unsure of the proper privileges, choose them all.

Then go to the page that was generating the error establishing database connection error and reload that page. Everything should be working normally now.

I hope this information helps you! If you have any questions leave a comment below or ping me @WPLearningLab on Twitter.

--------------

If you want more excellent WordPress information check out our website where we post WordPress tutorials daily.

Connect with us:

[utkxsh_old]

Thank You Very Much Much I am 10 years old website builder, social promotioner, app builder and this tutorial really helped me

[turboromy]

Wow. You saved me. Somehow, my problem isn't yet gone, but got me a step closer. I was about to quit this job. Thank you !!!!

[tallboy]

I'm running localhost with this same issue. Went to the database and did like you instructed and it works. Thank you so much. I didn't experience this issue with the same setup on other machines.

[caryhuff]

Bjorn,
You don't know how you saved me. I can't thank you enough.

[ProPlayer-zkkb]

Thank you, it works. I'm using localhost and was unable to create a database. this video helps me

[jalitzanunez]

Thanks!! This video makes my day happier

[dercoss]

Thanks for sorting my problem. It was the 2nd step you describe in the text about assigning permissions that was causing my error. No other video seemed to mention that step.... Very relieved....

[ghgoonline]

Thanks so much, i spent the last 4 hours trying to fix this until you came my way

[watchandlearn]

Thank you soo much sir my problem has been sole....

[johnbill]

Thank you, you're amazing!
Keep it up.

[ScottVincentPhotos]

Thanks for the video. I had everything correct, but still could not connect. For the benefit of others, I had to switch out my localhost with my server name/url on the Fatcow host. Seems to work fine, but hoping that what I've done is correct. Thanks again for all of your videos Bjorn!

[ernestoalonsor]

I updated my Wordpress and apparently my database was deleted :S Is there a solution? I don't know if there's a way to create again the database or something, I don't have a backup of it, so perhaps I'm screwed. Your videos always have save me, thanks so much for this content!

[FFYouTubeFactFusionYT]

I need help this happened in my mobile phone and I don't know what to do please help

[tolulopedahunsi]

WOW works like a charm with just one click. the error occured after i deleted the contact form7 plugin from wordpress dashboard. still wondering why this happened. Pleaselet me know if u have any idea. Thanks

[quamarroshan]

hello sir
actually I was used wordpress database reset after that it's showing

establishing a database connection
If your site does not display, please contact the owner of this network. If you are the owner of this network please check that MySQL is running properly and all tables are error free.

Could not find site Searched for table wp_blogs in database i5368684_wp1. Is that right?

What do I do now? Read the bug report page. Some of the guidelines there may help you figure out what went wrong. If you’re still stuck with this message, then check that your database contains the following tables:

wp_users
wp_usermeta
wp_blogs
wp_signups
wp_site
wp_sitemeta
wp_registration_log


What can I do
Please help me

[JoseGarcia-ypmr]

Nothing done in this tutorial worked for you? create another database, even if you created the one you are trying to connect 5 minutes ago, just do it, took me 2 hours to realize that i needed to create another one.

[potatchip]

I did this with a subdomain but it still doesnt work :(

[Maha]

I noticed that everytime i try to add or edit something on my website, it gets cut off and then i get this error message, it useually disappears in a while, but it wastes a lot of time because i have to wait until i can use my website again, really boring.

[akashaqib]

Hi, When I install wp rocket speed up plugin into the WordPress & save changes, then it shows this database error. any reason for that, I am wired now. pls, help.

[TopAPPSTamil]

bro iam using 000webhost but my sql isnt seen plz fix