Error Establishing Database Connection

I get this message a lot when I’m moving my WordPress databases from my localhost to my testing server. What I usually do is change the password in wp-config and on my permissions on MySQL. For whatever reason that usually kick-starts the blog into being recognized.

The other thing I always do is double-check wp-options table on my MySQL database and just make sure that I’ve got the right blog URL in ‘siteurl’ and ‘home’.

Good luck,
A.

@epymetheus what you should do is have a folder SYn so when you do testing you don’t have to transfer and the updated one will update the other if the update is good like this

https://www.allwaysync.com/

So SERVER (HOSTING SITE BLAHH BLAHH BEEP)
this is mine stuff
SEND 192.0.0.0 port 80* or what ever

Downloading Info From ip blahh port blahh
ok cool updated
Updater (TESTing Testing BEEP)

same way works when you hit update host computer

saves alot of time and hassle

@master-haxs – Thanks for the heads up. I’ll give it a try.

A.

@epymetheus says: What I usually do is change the password in wp-config and on my permissions on MySQL.

Okay, how would I do that, please? I know about the config file, but where would I get to permissions in MySQL? (I’m a total novice at mysql, all I know how to do is set the ID info). Are you advising to change the two passwords and make them different from each other?

also: double-check wp-options table on my MySQL database

Where do I find that? – thanx

[Edit!] Oh, I found it in PHPAdmin… But I don’t know what to do with it, I’m afraid I’ll break something, lol

Hi Blue,

Sorry for the long wait. My apologies.

So, to change the password you have to have access to your MySQL DB. I’m going to assume that you do. To change the password start at the MySQL dashboard, then select “Privileges.” From the Privileges menu, find the user that you’re looking for, the same one that you specified in your wp-config file. Once you’ve found your user, click the “Edit Privileges” button on the far right-hand side of the menu (usually a pencil or a pencil with a person icon). Once on the user page scroll to the “Change Password” box, click the Password radio button, then enter the new password twice, then click “Go” in the bottom right-hand corner of the box. This will change your user password on the MySQL side.

Glad to hear you found wp-options. There are two entries you need to check in wp-options. The first is line one of the table, which is “siteurl”. This needs to match exactly the url of your site. The second line is on the second page of the table, so click the single arrow at the top of the table to go to the second page. This entry is option-id 39, and its name is “home”. This entry also needs to be set to the exact URL of your site. They should be correctly set, but if they’re not click the edit button (pencil icon) on the left-hand side of table to edit them. Once on the edit page change the URL to match the URL of your blog, then click “Go” in the bottom right-hand corner of the box. That should do it!

I hope you’ve had some luck with your blog. If so, please post what solution worked for you to help others with the same problem.