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
apache and mysql are different things.... try 'localhost' as your MySQL server. If that doesn't work ask your host support
Is there a blank space at the end of the server name ?
try this
server:localhost
userame:root
password:(dont type anything if you didnt set 1)
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!