Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Possible to have database on another server?


backpurge

Recommended Posts

Posted

Hi,

 

I've set up OSC multiple times before but have never needed to do this. Pretty much I have a customer with a web hosting company that they want to stick with but they don't offer MySQL databases. I figured I could just install the /catalog files on their server and then host the database on our server. So I did that but when I go to install and input our database server/username/password it uses the localhost instead of the database server IP I put into the form.

 

Ex.

 

OSC /catalog files installed on domain.com

 

55.66.777.888 - Database Server

username - Database Username

password - Password

db_name - Database Name

 

And I get this -

 

---------------------------

 

There was a problem connecting to the database server. The following error had occured:

 

Access denied for user 'username'@'domain.com' (using password: YES)

 

Please verify the connection parameters and try again.

 

---------------------------

 

So it uses domain.com even though I put in the IP address 55.66.777.888. I've also tried it using the our server name mysql.domain.com but that didn't work either. These values always worked when I had the /catalog files on the same server as the database.

 

Any ideas?

 

Thanks!

David

Posted
Hi,

 

I've set up OSC multiple times before but have never needed to do this. Pretty much I have a customer with a web hosting company that they want to stick with but they don't offer MySQL databases. I figured I could just install the /catalog files on their server and then host the database on our server. So I did that but when I go to install and input our database server/username/password it uses the localhost instead of the database server IP I put into the form.

 

Ex.

 

OSC /catalog files installed on domain.com

 

55.66.777.888 - Database Server

username - Database Username

password - Password

db_name - Database Name

 

And I get this -

 

---------------------------

 

There was a problem connecting to the database server. The following error had occured:

 

Access denied for user 'username'@'domain.com' (using password: YES)

 

Please verify the connection parameters and try again.

 

---------------------------

 

So it uses domain.com even though I put in the IP address 55.66.777.888. I've also tried it using the our server name mysql.domain.com but that didn't work either. These values always worked when I had the /catalog files on the same server as the database.

 

Any ideas?

 

Thanks!

David

 

consider username_username

consider dbname_username

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...