Host not allowed to connect to mySQL?

[R08]

Hi,

 

I've finally got my site to actually start trying to load, thanks to some help from Azimpact earlier.

 

I'm now getting the following error:

 

* Warning: mysql_connect(): #HY000Host '###.##.###.##' is not allowed to connect to this MySQL server in /home/rapto/public_html/includes/application_top.php on line 160

 

* Unable to connect to database server!

 

Where ###.##.###.## is my proxy's IP.

 

Any idea what might be causing this?

 

My line 160 will differ from other peoples as I've added/removed stuff from appliacation_top.php.

 

Would like to add that my site works just fine locally so this is not an error I've created in code.

 

Any help would be much appreciated.

 

TIA,

 

Rob.

[alibaabaa]

Hi,

 

I don't kow what it is you are doing but I had this problem when installing the OScommerce software and instead of my ip address or site URL I had to put just 'localhost' instead and it worked.

[R08]

Thanks for replying,

 

this site is not installed on the local host but on an actual web server.

 

Are we on the same page or are you talking about a local installation?

 

Cheers,

 

Rob.

[Guest]

Thanks for replying,

 

this site is not installed on the local host but on an actual web server.

 

Are we on the same page or are you talking about a local installation?

 

Cheers,

 

Rob.

 

I use local host and that is an actual server, for your webserver the MySQL server is local. Try localhost. You can always set it back.

 

HTH

 

Giovanna

[R08]

That worked, thanks a million, I'm now getting the following error:

 

* 1046 - No database selected

* select configuration_key as cfgKey, configuration_value as cfgValue from configuration

* [TEP STOP]

 

Again, this works without a hitch locally, this is only happening on the host. Any ideas?

 

TIA (again),

 

Rob.

[R08]

Stop the press, I've done this now, thanks for all your help!