Cannot connect to MySQL db on hosted server

[robmc]

I am installing CPG on a 1and1 hosted server, the MySQL host is a dbXXX.prefora.net server.  I have other db's running here and I am able to connect without any problems.  I am sure of the database name and user/pass. I can ping the host name, I can phpMyAdmin to the host name, but Coppermine will not connect. I have tried several different things like putting http:// as a prefix to the host name.....
The error is :

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Unknown MySQL Server Host 'dbxxx.perfora.net ' (1)

I am pretty sure its an Apache Server., with PHP v4.4.2 and all the SQL values are correct.

any help would be greatly appreciated!!!

Rob

[Stramm]

apache and mysql are different things.... try 'localhost' as your MySQL server. If that doesn't work ask your host support

[Nibbler]

Is there a blank space at the end of the server name ?

[Vargha]

try this
server:localhost
userame:root
password:(dont type anything if you didnt set 1)

[Joachim Müller]

That would be a ridiculously unsecure setting to have. You can't try out mySQL settings, you have to know them. When in doubt, ask your webhost. Recommending silly default values is not a good idea, it will leave the impression those default values would be OK. They're not!