Changed database password now site won't load

[waterloominis]

I'm a newbie, so please forgive my ignorance. My web guy disappeared and now I'm trying to recover.

I changed the password on my SQL database on the hosting server, and now my store site won't load and my admin page won't load, so I'm guessing I somehow "cut off" access from my store site to the database. Can anyone explain to a total layman how to get the site back up? I can't restore the old password, if that's the issue, because I didn't know it (he literally disappeared and left me with no info) and so reset it.

Can anyone help me? Again, I'm a layman so I don't understand programming, computer talk, databases, or Zen Cart...I'm just trying to get my little part-time web store back on line.

Thank you very much, in advance,
Rob

[stevesh]

Did you edit admin/includes/configure.php and includes/configure.php to reflect the new DB password ?

[RescoCCC]

Did you edit admin/includes/configure.php and includes/configure.php to reflect the new DB password ?

I'm guessing the answer is no.

[waterloominis]

Thank you both so much your replies, and no I didn't. Where would I find that ain etc? Please forgive my ignorance...I'm just trying to figure this out.

[stevesh]

You need an FTP program to access the files on your Zencart sever. Use that to download the files I mentioned to your computer, open them in a text editor and change the DB password to the new value. Then upload them back to the server, overwriting the ones that are there.

[RescoCCC]

You'll be looking for this section:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'your_username');
define('DB_SERVER_PASSWORD', 'your_password');
define('DB_DATABASE', 'your_database');

[waterloominis]

Thank you both very, very much and I did indeed find those locations and changed the passwords. It worked sort of for the store site: it now comes up on the internet, but it shows as down for maintenance and there is the security warning at the top of the page that I need to change the permissions for the file /home/content/r/e/d/redtoorange/html/store/includes/configure.php. I followed the instructions in an FAQ link, but that didn't work. So I called my web host support, and while they were very friendly the instructions they gave me didn't work either...can't make the warning go away. I went to the admin...configure file and to the store...configure file, and both have READ as the only permission for web viewers. So now I've another hurdle to figure out. Any ideas?

Hurdle two: after changing the password in the database for the admin configures file, I now get a blank page when I click my link for the admin login page I had before. Again, any ideas?

I do apologize for begging for so much information, but this is a complicated and slow process for me, trying to figure out how to handle this webstore that I wish I had learned so long ago. If you or anyone else can help me to the next step I sure would appreciate it.

Thank you!

[RescoCCC]

can't make the warning go away. I went to the admin...configure file and to the store...configure file, and both have READ as the only permission for web viewers. So now I've another hurdle to figure out. Any ideas?

What are you using to set/change the permissions on the file? If it's an FTP program, they frequently won't work for setting it to 444. If you have cPanel provided by your host, log in there, open up legacy file manager and set the permissions from there. If that doesn't work, ask your host to set it to 444.

after changing the password in the database for the admin configures file, I now get a blank page when I click my link for the admin login page I had before. Again, any ideas?

That means you screwed something up when you edited it. Look for a missing hashmark, extra characters, extra carriage return, etc. Make sure you're doing your editing in a plain text editor.

[waterloominis]

Thank you so much for the reply! I did use the FTP File Manager on my hosting site (Domains Priced Right). I don't know if they have the cPanel thing but I didn't see it anywhere.

I'll look again at the admin configures text; I downloaded it to my computer, used a plain text editor to change it, then uploaded it. Perhaps my fingers hit something extra? I'll look. Thank you!

[RescoCCC]

If they have cPanel it will be found at your_domain.com/cpanel.