Help Linking Oscommerce To Database

[skylab001]

I have an Oscommerce based site that I've been running for a few years now and I'm in the process of moving over to TCH from our old host. I am trying to figure out how to connect the database during the install procedure? I have set-up the database in cPanel, but I have no idea what it's address would be on the new TCH server. Also I have not re-directed our Domian name yet because we can not afford to have any downtime in our shop. Not sure if that makes a difference. I need to get this new site set up and all the bugs worked out before we go live on the new server. Can anybody tell me how to access my database?

 

Thanks

[TCH-Bruce]

Welcome to the forums, skylab001

 

I'm sure someone will be along to help you. Normally the host address is "localhost".

[TweezerMan]

Welcome to the forums, skylab001!

 

I believe Bruce is correct - you should be able to connect to your MySQL database by configuring OSCommernce to connect with the hostname of 'localhost' (though I don't have any experience with OSCommerce).

[TCH-Thomas]

Welcome to the forum, skylab001

[TCH-Don]

Welcome to the forum, skylab001

[skylab001]

Welcome to the forums, skylab001 

 

I'm sure someone will be along to help you. Normally the host address is "localhost".

<{POST_SNAPBACK}>

 

so what would the address string look like. ie. www.localhost.com/username_databasename ??

 

is that correct?

[TCH-Bruce]

The configuration variable for the host would just be be 'localhost' without the quotes. It's not an address.

[skylab001]

ok I tried using 'localhost' without the quotes as my Database server in the oscommerce setup, then my TCH username as the Username in the osc db setup, then I put int my sql db password and my sql db name which is mytchusername_databasename,

 

but I still continue to get this error:

 

A test connection made to the database was NOT successful.

The error message returned is:

Access denied for user: 'xxxxxxxxxxx_@localhost' (Using password: YES)

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

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

 

I must be doing somthing wrong?? This was so easy on my old server.

[TCH-Don]

just to doublecheck

what you have so far.

 

You went to cpanel > MySql

and created a database

then created a user

and then added the user to that database

all in MySql.

 

the connection info

will look like this

 

localhost: localhost

Database: YourCpanelName_yourDatabaseName

user: YourCpanelName_DatabaseUserName

Password: *******

[skylab001]

just to doublecheck

what you have so far.

 

You went to cpanel > MySql

and created a database

then created a user

and then added the user to that database

all in MySql.

 

the connection info

will look like this

 

localhost: localhost

Database: YourCpanelName_YourCpanelName

user: YourCpanelName_DatabaseUserName

Password: *******

<{POST_SNAPBACK}>

 

I made sure that I was inputing things the same way and now I am getting this error:

A test connection made to the database was NOT successful.

The error message returned is:

 

Access denied for user: 'YourCpanelName_DatabaseUserName@localhost' to database 'YourCpanelName_DatabaseName'

 

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

 

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

 

So I guess it is now trying to access the DB but with no luck, as before it was just giving me the error access denied.

[Pendragon]

 

You must create the user name in the database using cpanel before you can use it, you cpanel name isn't automatically added to the database when the account is created.

[TCH-Don]

You miss quoted my last part

 

Database: YourCpanelName_YourCpanelName

should be

Database: YourCpanelName_yourDatabaseName

 

But I think that is what you have.

 

the most common problem is

not creating a user

and then adding the user to the database

all of this in MySql.

 

Thats what the error looks like.

 

 

I too do not use OSCommernce,

so if this is not it,

hopefully someone that uses it will be along to help.

Don't give up.