Site has gone down! Big problem, please help!

[No-idea]

Hellooo there!

 

I created a website for my uncle acouple of years ago and I have been getting emails from fasthosts saying I must change the password. Now i have done this the entire site has fallen appart!

 

When you go the the site it says:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'zenshop'@'server213-171-218-199.livedns.org.uk' (using password: YES) in /home/fhlinux199/p/phoenixfactory.net/user/htdocs/catalog/includes/functions/database.php on line 19
Unable to connect to database server!

 

I cannot remember what the password was or how I got about changing anything.

 

Please please anyhelp is welcome!!!

 

Thank you!

[DejaVu]

Not sure if this is a good idea, but will help you get out of a hole!

 

READ THE WHOLE THING FIRST!

 

BACKUP EVERYTHING INCLUDING DATABASE IN PHPMYADMIN!!!

 

Download the same version of OScommerce you have got on your server. (M2 or RC1)

 

Upload the 'install' directory and the configure.php files in '/includes' and 'admin/includes'

 

Goto your URL and run the install process again. Then rename the install directory like I have to something obscure(instead of deleting it!)

 

Reupload your old database without the administrator table (in the SQL file!)

 

Your new Username and Password should be in effect and your whole site should work again.

 

I MAY BE WRONG AND IT COULD BE A WORSE PROBLEM.

BUT THAT IS THE FIRST THING I WOULD DO.

[Gauravs]

You don't need to run the setup all over.

Where have you changed the password?

 

If you have changed hosting password, and if your control panel indicates that same password is used for database, then simply edit

/catalog/includes/configure.php & /catalog/admin/includes/configure.php

Main Entries are listed below

// define our database connection
 define('DB_SERVER', 'xxxxxxxxxxxxxxxx'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'xxxxxxxxxx');
 define('DB_SERVER_PASSWORD', 'xxxxxxxxxxxxx');  // <--- You would need to type in new password here, replacing xxx
 define('DB_DATABASE', 'osCommerce');

 

Just replace old password with new one, and your cart should get functional again.

 

Cheers

GS