How To Fix “Error Establishing A Database Connection” In WordPress

[@learningsolutionsgroup]

Thank you, I was able to repair my database and get my site back online using your tutorial

[@bravesolani1320]

Thanks Bro... First Option didn't work but the second worked instantly. Great Tutorial, straight to the point... Sweet.

[@muriukified]

This a good brief video to the point. Only thing is PDO connection seems to be the standard now as Mysqli is deprecated in most hosts. Also line2 of test code has a typo: $test Connection should be $testConnection. In my case, everything was set up ok but didn't work. I had to create a new user and assign to the database for WordPress to work. Then I deleted the old user. Always try that before trying to repair the database.

[@philtaylor3098]

This video makes too many assumptions. In my case I've only just created a DB so it can't be incorrect and there is no corruption because there's nothing in ( no tables ), I've copied and pasted the username and password so I know they're correct and yet wordpress still gives me the message "Error Establishing A Database Connection"

[@ed101poti]

did you manage to fix it? i'm having this same annoying issue for some time now and can't seem to find an answer. a fresh install and still an error in connecting to the database which is on localhost...

[@ProGamer-ho7lz]

this message annoys me do you know how to stop it and fix

[@muriukified]

@@ed101poti Always test with a fresh new user with all privileges

[@marcchami8851]

Did anyone figure this out? helppp

[@awfulname7610]

Same issue, anyone found the solution?

[@redirajahdielrosario3645]

THANK YOU SO MUCH! IT WORKED! I modifed my SQL database and that error popped up after the update! THANK YOU AGAIN!!!!

[@kamalhines]

OMG thank you so much problem fixed with the first option,,,, you are genius among men.

[@godlabelfoundation]

This helped me to address my issue. i had previously changed my cpanel name and this changed the username of all my databases. so i logged in to my cpanel, root directory of my website and edited the wp config file and put the correct username of my databases. i first checked the username of my databases using the cpanel file manager.

[@1gk]

Thank you!!! Learning about the wp_options table in the database was a lifesaver for me.

[@elegantthemes]

Nice! Glad to hear it helped 👍

[@tomislav_._9224]

Thank you, this tutorial saved my nerves and brought my site back to life! :)

[@chaoSefat]

I don't have wp-config.php not even in the zip I downloaded from WordPress.org

[@mhpreach]

What I need to know is what directory the sql file goes in on the server. I’m having to migrate my word press site manually. Due to upload file size limit. What directory contains the SQL file?

[@jordan17bliss]

Thanks for the fix! Editing the wp-config.php file was exactly what I had to do. Working great now. Life saver.

[@nazimbelli937]

Any help pls, im using vultr vps server and i faced this issue and i cant repair it im confused , should i connect my server with FTP like filezilla or i should enter to that by PUTTY .PLS ANYONE CAN HELP .THANKS IN ADVANCE

[@tarjumanemughal7843]

how you edit this, my FTP said it's read only... my hosting is from godaddy kindly help

[@Ax4k]

I get big traffic spike, I get this error, but server was up. so what should I do in this case? it comes for some time, then the site working. you give solution for 1 and 2. What about 3?

[@cinemaofsounds]

I didn't give my new database privileges and the MySQL databases allowed me to do that thank you.

[@LoopcrateAudio]

Thank you SOOO MUCH for this! Was freaking out after trying to fix it for hours and this worked like a charm! 👍🏼

[@modz9711]

Hey thanks for video tips, But I have an issue when I go to the phpnyadmin and navigate to the wp-options of the current database I'm not able to see the site url instead there's something else. What could be the reason for this ? Thanks in advance.

[@jonthemachine1970]

2:16 lost me. Thanks for showing us how smart you are.

[@alextrd7951]

my site is hosted on AWS and i searched the mysql folder via filezila but couldn't find that file which contains database name and other credential. do you have any documentation for AWS or is there any specific name of that file ?

[@ilhanhassan7941]

I have a question if I’m on a website and error establishing data connection it it something on my side or should I just wait for the website to fix itself

[@ОлегМихайлов-к2щ5э]

I have just restarted my server and the website works well now!

[@vladimierapostol5959]

The site was doing fine until "Error establishing a database connection" appeared in rare occasion the site could be accessed sometimes not is it the site problem?

[@GSapStark]

what if I can't find the wp-config file in phpmyadmin ? it's nowhere to be found and I can't go forward with troubleshooting :(

[@patorjk]

Dude, you are freaking amazing!! I had a user to my site email me about getting this when the search functionality was used. I noticed it also appearing for other spots on my WordPress blog too. I emailed support, but got no response. I figured since it was almost Christmas I'd be SOL. However, after trying your test-connection code, I was able to get an idea of what was wrong and fix the issue. Anyway, thanks for making this video!

[@nj5195]

A few days ago i click on ''empty'' on wp_option in phpmyadmin.. Now i don't have siteurl and home in phpmyadmin. I checked everything and try with wp allow repair, but when I remove this code, again is the same ''Error Establishing A Database Connection'' I try to add a new user, and update wp-config, still the same. I make this testconenction.php and when i start it says: Connection successfully. Debug log is ''mysqli_real_connect(): (28000/1045): Access denied for user '****''localhost' (using password: YES) in /home//wp-includes/wp-db.php on line 1635

[@d4gameplay317]

Amazing! I had troubles with this after moving hosts and the repair code (and repairing database) worked perfectly. Thanks so much!

[@thetechguy47]

the same here

[@simersingh9927]

actually i am new to wordpress my database connection is not established via wordpress.org showing some connectivity error and i also not having config.php file its config-sample.php what should i do things i have tried making other user to the database and give previliges but same error message is shown and with installation of wamp server i got marinedb as well

[@Techbox1985]

okay and what if nothing of this 3 fixes helps? sql server are the same as webserver (other programs has access) the username and passwords are right (used copy paste! and trible checked this) corrupted database? how the table WP_database is empty ! so now how to fix? the maria-db_error.log has no rejection request errors logged. :s

[@PetersonCharlesMONSTAH]

I didn't get the option to choose anything it still shows me error establishing a database connection

[@Ghaleon]

I'm trying to run my wordpress in localhost so I can make a few changes and upload again via FTP. But when I downloaded the files I'm receiving this error because I don't have that database. How may I get the wordpress database and have it locally?

[@guyeeeee]

Thank you! Had this for 2 days, had to create a new user name as you show and now it works.

[@robgarza6591]

This video indirectly helped me solve my problem. The issue was with the config.php file. Thanks!

[@saajidhnawwar8505]

theres no file called wp-config.php instead only wp-config-sample.php is available. where can i find it?

[@JamesNdungu1]

Mine was a simple WordPress PHP thing repair. Thank you, solved my problem :)

[@piachitasji5846]

Thank you for this tuto. So I can't connect me to the database. After did every steps, the error still appears :'( I made it with WAMP, maybe do you think 'll be different with XAMPP ? Thank you so much

[@jordanrollicks1289]

I didn't understand where to create a new file, help me plz

[@tapiwanashejamielkazembe2346]

You are soo good, thanks a million times buddie.

[@PraveenKumar-ts2ok]

how to access wp-config.php file? I am not even able to login into admin. and FTP. it gave me an error "Unable to read the indexed puredb file (or old format detected) - Try pure-pw mkdb" not even to able login wp-admin. it showing the same error esablishing a database connection error to me. i am using goggie host provider hosting account they haven't given me any answer. can you help me .

[@topuinternationallimited7214]

Many thanks, when i fix it, i solved the problem, thanks guys

[@skalo1840]

i really dont know what my host is cause i dont know anything about this,but is this just for website owners btw i have the same problem

[@JenniferVerdin]

Thank you!! Your video helped me fix my issues even tech support from my hosting company couldn't fix :) appreciate it!

[@aritora778]

Thanks a lot. You are a life savior.. and job savior too!

[@nazimbelli937]

Any help pls, im using vultr vps server and i faced this issue and i cant repair it im confused , should i connect my server with FTP like filezilla or i should enter to that by PUTTY .PLS ANYONE CAN HELP .THANKS IN ADVANCE

[@leonkambarami8091]

Thanks first option worked. U r legend

[@arjunmpgupta]

Hi even after pasting code in wp-config file, this site repair page is not working

[@kindahall]

same

[@lgds.gaming8385]

where can i find wp directory ?

[@CarlosDiazChico]

Hola!!..When I tried to access the ftp file, I got this message: Under Construction The site you were trying to reach does not currently have a default page. It may be in the process of being upgraded. Please help!!

[@SaifZiya]

I've started getting this error after upgrading my VPS (1 GB) plan to VPS (2 GB) plan. On VPS (1 GB), my website was getting around 500 users at the same time (working fine). But, after switching to VPS (2 GB), it could only handle 2 to 3 hundred users. Any idea what the problem is?

[@paprika8177]

The testconnection.php only shows a blank page, nothing else... HELP!

[@brokegirl123]

After add new database I dont have any option like add a new user ..

[@gustavofarianascimento2959]

Data base repair works for me! Thank you!

[@Qamre_Alam]

I am really very grateful to you bro... Heartily thanks from India...

[@homeiscool1019]

checked the msql, it says it is offline. does it mean that the problem is w/ my web hosting? how d i fix it?

[@helpwp-wordpresstutorials1741]

kzbin.info/www/bejne/maOodKGIha2bmtE

[@balajeemishra]

Someone please help me..I am unable to resolve my error..I have tried everymethod nothing seems to work in my case.

[@yourdailyfails1]

i deleted my mysql database of wordpress how can i remove it. or recreate database

[@FemaleTraderRamya]

Great explanation for non-techies 👍

[@EmileJobity]

Line 2: @4:34 should be $testConnection

[@emsa8090]

how can I fix it when i'm trying to get on the website through my phone and it shows the error?

[@sylvestersmyles-crentsil5758]

Thanks man, really needed this.

[@helenmendoza5956]

can i just say you are the best?!!!!!

[@kuismakansala7666]

The thing is I don't own the site and I don't have those wp-xxx.php files.

[@garrin5922]

my problem is... this error is came out when I am installing wordpress locally

[@Groooovs]

You saved my life my man! Thanks

[@elegantthemes]

You're welcome Manu! 😄

[@webdesigncfgromania579]

Hi. I was able to restore the database. Very good information. Thanks!

[@dasd.bilany]

It still says error to establishing connection for reference exactly what i did ___________________________Code Asked to put inside________________________ (note into php.config) define ( 'WP_ALLOW_REPAIR', true ); after i put the code in i went to the website and did mywebsite/wp-admin/maint/repair.php ________________________________________Results_____________________________________ Same error word per word Error establishing a database connection __________________________Code i had at very start____________________________ (Note i did not erase any data only simply added what was told)

[@CK__NATH]

Sir l m from lndia, Sir pls help me l have same problm ,..my site not oppening

[@tanusreebanik1993]

Can anyone tell me how do I get this php my admin panel?

[@3-dog-solution]

Hi chaps, .. I still haven't sorted out my localhost XAMPP issue, but a few things have poped up when trying out the above examples. Firstly: PHP v5.5.0 scrapped, or depreciated the mysql_connect() function, and it seems that PHP 7 hasn't got the equivalent, .. I call that bullcrap. After a lot of precious precocious digging: mainly coming off of the many precocious precious programmers out there, all humming and arring as they are wont do; then I've discovered that mysql (i) can be used instead. Note the [ i ] in the new function, and you can forget all that confusing blurb that goes on about PDO-functions, especially if all you want to do is test the bloomin' thing. Also: the example shown in connecting to your database was -- $test Connection, -- when in fact it's $testConnection -- (no space.) Here's the code, .. Running it tells me that I can connect to my database, but I still can't get XAMPP to load my web-pages. Note: not a *new* install, .. it was working fine last night, .. then it wasn't today. My journey continues .. hope the above helps.

[@joshuajackson7941]

Thanks a lot. U help me a lot!!! I'm a beginner

[@duderz6876]

I Dont get it, I Got the error on Xbox one downloading minecraft mods, Its not my website Annnnnnddddddd i got no pc

[@digitaldealsshop]

Thank you so much! This happened to me today and I followed your instructions and all is good now! Again, thanks! Great video!

[@marufhossain794]

Hi, i Don undrestand his english, will you help me pls what is actually he done

[@marufhossain794]

I dont have wp-config file

[@Jesus-lv9mu]

How can you find the password, did I miss it in the video or am I just supposed to know?

[@farhanahmad5934]

Great video and troubleshooting tips 👍

[@naderabouchakra2638]

Thank you that worked for my website

[@vipergx]

just in case anyone lost the wp-config file like I did. when recreating it (making sure u have the right credentials for the database inside it) set the correct permissions for it. 0600 in my (and most likely your) case. cheers

[@beautifulpapillon]

Thank you. It was helpful.

[@spagetka99]

Thanks god for people like you. You saved my life :D

[@nazimbelli937]

Any help pls, im using vultr vps server and i faced this issue and i cant repair it im confused , should i connect my server with FTP like filezilla or i should enter to that by PUTTY .PLS ANYONE CAN HELP .THANKS IN ADVANCE

[@heartfeelings8172]

i can't find code from blog post please help

[@elegantthemes]

Hi there! 👋 Please, check the lines of code here in the article: www.elegantthemes.com/blog/wordpress/fix-error-establishing-a-database-connection-in-wordpress define('WP_ALLOW_REPAIR', true); UPDATE wp_options SET option_value='examplesite.com' WHERE option_name='siteurl'

[@Rockwellentrtainmnt]

@@elegantthemes No you can't. Test Connection code is missing from the blog.

[@helmantmc389]

Please make a video about how to set meta description in category layout homepage in Extra. This is a big problem for a lot of people.

[@qlmcoachingsuccessblueprin6119]

thanks for your help it did work as you said

[@JulesIvanCGaray]

YESSS!! Thank you so much!

[@sheikhhussein6233]

Thank you so much buddy... You're a life saver

[@ivofrancisco357]

In case someone is using MAMP on Mac and without using a Password. The issue can be fixed by adding root as a password

[@L0LIpOp]

Not working at all. Warning: file_put_contents(): Filename cannot be empty in C:\xampp\htdocs\wordpress\wp-load.php(2) : runtime-created function on line 1 Error establishing a database connection

[@TechNow813]

Corrige seu USUÁRIO que você criou no Banco de dados do Mysql. change your USER information you created in the Mysql Database. ALTER USER ‘Usuario’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘SENHA-DO-USUÁRIO’; SEGUE O LINK das informações no site do mysql. FOLLOW THE LINK of the information on the mysql website. dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html dev.mysql.com/doc/refman/5.7/en/native-pluggable-authentication.html

[@accord93rg]

Where do I find the root ????

[@djjahnotice7000]

how do i edit the php file

[@philtaylor3098]

You don't get both a wp-config-sample.php and a wp-config.php. You're instructed to edit the wp-config-sample.php. I swear you used to have edit the wp-config-sample.php file and then rename it AFTER editing to wp-config.php

[@JeffDeWitt]

That did it, repairing the wp-config-php file fixed my problem, thanks!

[@nuradrianabintimohdyuslebi6538]

Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: NO) i keep receive this error message, anyone know what to fix

[@heartfeelings8172]

how can i find

[@videotodvdscotland]

Thanks so much for this fixed my issue

[@vargabrigitta8121]

I don`t have config.php file!

[@ernestofavio6735]

neither do i, could you solve it?

[@Mrfeezu]

How to fix it in android please help me

Thanks, worked perfectly for me!!

[@abenezer3937]

Thanks! config repair works just fine

[@nzeefurqan1650]

doesnt work for me..dont know why

[@haseebabdul-p3o]

Thank you so much 👍

[@lailaisolutions4305]

WONDERFUL VIDEO!,, THANK YOU, WORKED LIKE A CHARM!..

[@ismetomerkoyuncu1179]

Thank u so much repairing worked

[@ghaffarhunzai]

Dear this is a wonderful tutorial ... keep on your great work ...

[@osashills1]

Thank you for this informaion .