Trouble installing with godaddy.com

[CGIMana]

hi I hope I can get some input on this soon.

I am using godaddy.com and my hosting and mysql server.

During Install I get the error cannot connect user: blablabla was denied using password yes.

 

I call up godaddy.com, talked with them for 40minutes. They say that osCommerce install is looking for a mysql server that is on the same server that the site is on, and I need to change the programming to look at other servers. But that's what the Server: field is for. They are looking into it further, but I think it's just their service. Yet not knowing anything about php I have no idea what they are even talking about.

[sanityfair]

This might help, but since Im not exactly sure what the problem is, it might not, and this is just how databases work for me, though I think its pretty uniform with other servers too.

 

There is a database name, username and password. For example, the database name is catalog, the username bob and the password yes.

 

Sometimes databases use the username you have for your entire site as a prefix to the database name and username, but not the password.

 

So for example, if my username for my hosting is sanityfair, my database name, when I fill in the fields for installation, is sanityfair_catalog, my username is sanityfair_bob, and then my password is just yes, no prefix.

 

Now I realize I might have just explained something you probably already know, but it doesn't hurt to try to help! :)

[CGIMana]

It was a nice attempt. The tech help at godaddy.com would have known that. But the webhost and the database are on different servers. what it is, is that they think oscommerce is programmed to only use databases that are running on the same server (ie same ip address).

I need to know if this is true. And if it is, how to I make it not true? (I'm am 99.99999999999999% sure that it isn't true already.)

[satish]

It was a nice attempt. The tech help at godaddy.com would have known that. But the webhost and the database are on different servers. what it is, is that they think oscommerce is programmed to only use databases that are running on the same server (ie same ip address).

I need to know if this is true. And if it is, how to I make it not true? (I'm am 99.99999999999999% sure that it isn't true already.)

 

 

on your config.php file you will find localhost just change and make it point to the server where Godaddy providers had placed your data base.

 

Satish

[CGIMana]

on your config.php file you will find localhost just change and make it point to the server where Godaddy providers had placed your data base.

 

Satish

 

Did you catch the part where I can't INSTALL osCommerce?

[Iggy]

Did you catch the part where I can't INSTALL osCommerce?

 

I'm about to install osC for client next week. If I get the same hassle I think what I would do is install it locally then move the files to Godaddy and mod the config from there.

 

But that's just me :-"

 

Overall though you might look for another host.

 

HTH,

Iggy