Cannot connect to MySQL db on hosted server Cannot connect to MySQL db on hosted server
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Cannot connect to MySQL db on hosted server

Started by robmc, June 09, 2006, 06:00:27 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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)
Haalaa Boro Ye Chayi Vasam Dorost Kon Ta Man Ye Fekri Be Halet Bokonam ;) Ye Hendooneye Shotoriham Biyar Bizahmat :)
Visit My Site www.Rangarang.co.nr
Check Out My Gallery
www.Rangarang.co.nr/buddies
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fimg157.imageshack.us%2Fimg157%2F838%2Frangarang4xn.jpg&hash=48b4c3087515cafe09fc6d3f7ee19dce86328d8e)

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!