XF 1.2 Changed my Hostgator password and now my site has crashed

[MKSwni]

Hi guys,

Firstly, thanks for running a wonderful support forum. The search feature really does help but I'm still experiencing problems that I hope to get insight on.

I recently changed my database password through my control panel and immediately afterwards my website crashed.

After doing a bit of research on here (thankfully), I found that I also needed to change the password in my library/config.php file.

Instead of changing my password in that file, I went back to the control panel and inputted my old password. That way the password in the config.php file and the password in the control panel are the same again (So in effect, password A was changed to password B, but then back to password A in the control panel. That way the password there and in config.php aren't different now).

But it's been about 30 minutes and my website is still not up.

Is there anything I can do? I read on a previous post here that there can be a time delay but that user had reported only about 10 minutes. I'm hitting 40 minutes now.

 

[Andrej]

What is your forum URL?

 

[MKSwni]

What is your forum URL?

http://www.kayoforum.com

This is the error I'm getting:

An unexpected database error occurred. Please try again later.

Thanks.

 

[Andrej]

Looking at the page source, this is the error:

<!-- Access denied for user 'gyopo'@'localhost' (using password: YES) -->

Double check that the database username and password in config.php is correct. If everything seems correct to you, change the password again, and update the config.php file.

 

[MKSwni]

Looking at the page source, this is the error:

<!-- Access denied for user 'gyopo'@'localhost' (using password: YES) -->

Double check that the database username and password in config.php is correct. If everything seems correct to you, change the password again, and update the config.php file.

I've triple checked and literally the username and password both in the control panel and in config.php are the same

I don't know if this means anything to you, but I have two config.php files.

Could one be an extra that is messing with things? I checked both files and they have the same exact info.

 

[Jeremy]

One is a .default extension. It doesn't matter. Can you change your database password for the user you use individually? If you can (you should be able to), do it and update your config.php accordingly.

 

[MKSwni]

One is a .default extension. It doesn't matter. Can you change your database password for the user you use individually? If you can (you should be able to), do it and update your config.php accordingly.

I changed the password to something completely new in my control panel then accessed both config.php files (as I showed you above) and replicated the password there too.

Since I just changed the passwords, will there be a wait time for the database to set itself with the new password? Or does this typically happen instantaneously? This is getting really frustrating.

Thanks.

 

[MKSwni]

I'm literally hitting an hour of downtime now.

I've read this

http://dev.mysql.com/doc/refman/5.1/en/assigning-passwords.html

But I do not know where else the passwords can be incompatible besides config.php

 

[MKSwni]

When I change my password in cP, this is what comes up after.
Are there any other files relating to the services listed above I should access and dig into?

I'm not sure if this means anything to anyone.

 

[Jeremy]

No. If your database password is changed, all you need to do is update the config file. If you restore to your old password, does your site come back?

 

[MKSwni]

No. If your database password is changed, all you need to do is update the config file. If you restore to your old password, does your site come back?

Not at all. We (my partner for this forum and I) tried that, we tried changing it to a temporarily easy password, then back to our initial password. Nothing is working. I'm sorry that this is causing a lot of trouble.

Is there a way you could look into this further? We tried calling hostgator's customer service but we don't think they were serious about their 24/7 support.

Edit: Could changing the localhost to any other name help?

 

[Jeremy]

If local host worked before, it should work now, considering the error, it sounds as if cPanel failed the update. Your host is the ones best suited to help.

 

[MKSwni]

If local host worked before, it should work now, considering the error, it sounds as if cPanel failed the update. Your host is the ones best suited to help.

Thank you for all your help. I really appreciate it.

Will update this thread as I figure this out for others who might have this problem in the future.

 

[MKSwni]

I've figured it out.

I backed up config.php and put a copy on my computer, deleted config.php from my server, then re-uploaded the backed up file on my server. The site started working again.

Also for future reference, I suggest changing any information in config.php first then changing it in the control panel.

Thanks a lot for everything!