mysql access problems

[jsstevo]

Hi all,

I've just transfered over to eukhost and am having problems connecting to my databases.

The following is giving me my die message. I've created the uses for the database, linked them and cannot access.

$db_host = "localhost";
$db_user = "compsafa_(User Removed)";
$db_password = "(password removed)";
@ $connect = mysql_pconnect($db_host, $db_user, $db_password) or die ("ERROR! Could not connect to the Database Server");

An example is at http://compsafari.com/jonners/

Cheers!

[DPS Computing]

I'm no expert but is $db_host="localhost" correct? Just an incling I have based on the MySQL knowledge I have.

Also, are you sure you have set up the databases and users correctly, for example no typing errors in usernames, database names and passwords, in your control panel?

Hope that helps .

[jsstevo]

It was localhost before and i've searched this forum and still think it should be localhost.

I've also removed the users, set them up again and also copied and pasted them.

Cheers!

[DPS Computing]

Ah right ok then, sounds like you have those bases covered.

It could be completely unrelated but I recently had MySQL problems related to the cPanel update but all these should have been fixed by now so it is just a stab in the dark really (as cPanel released an update to fix these problems which I believe eUKhost has already applied).

Where were you testing the website before when it worked? On your own computer (with your own test server set up) or on another hosting companies site?

I brought this up as "localhost" is used with regards to refering to a local machine (like your computer) and as it is now on a remote web server I thought it might be causing a problem. So it was a bit of an educated guess (as I don't know tons about MySQL) whether there was something wrong with this line or whether it was right.

Hope that helps

[jsstevo]

This was a working website on another web server that has now closed down. I've checked the localhost bit out by searching on "localhost" and the post titled db-settings... shows this as being localhost too.

Cheers!

[DPS Computing]

OK then, so that can't be the problem, especially if you tried it out on another remote web server.

Sorry I'm out of ideas! Hope someone else can come along and help you!

[jsstevo]

Thanks for taking the time to help.

I mailed the support team on Wednesday but not heard anything back yet.

Cheers!

[esnail]

yes - "localhost" will be correct.

silly question but... have you setup the database in phpmyadmin?

[DPS Computing]

Originally Posted by jsstevo

Thanks for taking the time to help.

I mailed the support team on Wednesday but not heard anything back yet.

Cheers!

Thats strange they normally respond quite quickly. Have you tried using the LiveChat on the main eUKhost website? (www.eukhost.com). Or opening a new ticket might help (email to support@eukhost.com).

[jsstevo]

Sorted via the Live Chat

Resolution :-
I was using
@ $connect = mysql_pconnect($db_host, $db_user, $db_password) or die ("ERROR! Could not connect to the Database Server");
this should of been
@ $connect = mysql_connect($db_host, $db_user, $db_password) or die ("ERROR! Could not connect to the Database Server");
I.e. mysql_pconnect -> mysql_connect p removed.

From support
the connection string was using mysql_pconnect to connect to the server which is disabled on the server
so it should use mysql_connect

[DPS Computing]

Glad to see you got your problem sorted There very helpful and efficient on LiveChat (as is the support in general!)

That was a small thing to notice and know about, definitely beyond my MySQL knowledge!!