Database user login issue

[emorphe]

My store was working fine, but then I stuffed it up! Couldn't remember my database password (set up in my Mysql database), so I tried to add a new user in my control panel. Suddenly the whole store went kaput! Any suggestions on how to fix?

 

I've deleted the new user, but it still won't work. I didn't change the existing user.

 

Here's the error msg:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'user'@'localhost' (using password: YES) in /home/public_html/demo/store/osc/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

[multimixer]

My store was working fine, but then I stuffed it up! Couldn't remember my database password (set up in my Mysql database), so I tried to add a new user in my control panel. Suddenly the whole store went kaput! Any suggestions on how to fix?

 

I've deleted the new user, but it still won't work. I didn't change the existing user.

 

Here's the error msg:

 

With "control panel" i guess that you mean your hosts cpanel

 

So, ok, after you changed the user and password at the cpanel, you need to nform osCommerce about this change. To do this, you go to your 2 configure.php files (includes/configure.php and admin/includes/configure.php) and set the right username and password at this part of the file

  define('DB_SERVER_USERNAME', 'YOUR NEW USERNAME');
 define('DB_SERVER_PASSWORD', 'YOUR NEW PASSWORD');

[emorphe]

Phew! That fixed it (major relief)! Many thanks! :)

I went into those files and found the password, and re-set it.

[emorphe]

Hmmmmm, now the store is working again but it won't accept my login! I'm using the login (username and pwd) that was set for the database, and checking both those configure.php files I'm using the correct details. Suggestions? Is it looking for a different password?

[multimixer]

Hmmmmm, now the store is working again but it won't accept my login! I'm using the login (username and pwd) that was set for the database, and checking both those configure.php files I'm using the correct details. Suggestions? Is it looking for a different password?

 

Please make clear always what you mean exactly

 

What do you mean with " it won't accept my login!" Login to where? Do you mean your admin, or the user/pass for the database? The admin password is stored IN the database and has nothing to do with the passwords in the configure.php files. So, what exactly is your problem?

[emorphe]

Problem fixed - I downloaded a fix from this site. I was wanting to log in to the admin area of the store. It's now sorted.