Trouble Installing Oscommerce Php

[sunjata1]

Please help I am a newbie ... I almost finished installing the OScommerce shopping cart .... except for the step that ask for the database server ... I get error message :

New Install

 

Step 2: osCommerce Configuration

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Access denied for user: 'antarxc@209.51.142.186' (Using password: YES)

 

Please click on the Back graphic to review your database server settings.

 

If you require help with your database server settings, please consult your hosting company.

 

is there a special configuration for mysql server .....

[TCH-JimE]

Hi,

 

Open up mysql in cpanel and see whether the user is added to the database. If its not, it will produce the error you have. You will also need to check the password too.

 

Also, i think it should have @localhost and not your IP address

 

Let us know how it goes

 

Jim

[TCH-Rob]

I am running OSCommerce on my site. After you create the database you need to have the location localhost, the username of the DB ( cpanelusername_dbname) the the password. catalog/includes/configure.php should have;

 

// define our database connection

  define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

  define('DB_SERVER_USERNAME', 'cpanelusername_dbname');

  define('DB_SERVER_PASSWORD', 'dbpassword');

  define('DB_DATABASE', 'cpanelusername_dbname');

  define('USE_PCONNECT', 'false'); // use persistent connections?

  define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

[sunjata1]

thanks alot guys .... got it working ..... [wipes 4head] that was some hardwork .... thanks again .....

[TCH-Rob]

Glad to hear it. I have found every answer I needed in their forums. Never had to post a question there, just do a search for your question. Every issue I had was had by somebody else and there was an answer waiting. Have a look here. OSCommerce Forums