[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]

TCH-Bruce, on Apr 12 2005, 07:24 AM, said:

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:

Quote

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]

TCH-Don, on Apr 19 2005, 08:18 PM, said:

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:

Quote

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]

skylab001, on Apr 19 2005, 08:50 PM, said:

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.