database server settings.. - UK Web Hosting | Dedicated Server Windows and Linux VPS Forum

**Shaitan** · #1 (**permalink**) 24-04-2007, 19:51

Hello,

I've been searching on this forum but haven't found an answer yet:

I made a db in my hosting controller but can't connect to it...

It's a mysql-db, what do I have to use in my php-script for connection?

$database[dbserver]= ? ;
$database[dbuser]= ? ;
$database[dbname]= ? ;
$database[dbpass]="mypassword";

Greetings

**eUKhost.com** · #2 (**permalink**) 24-04-2007, 20:20

settings should be as following :-

$database[dbserver]= "localhost";
$database[dbuser]= "user_dbusername";
$database[dbname]= "user_dbname";
$database[dbpass]="mypassword";

**hairyfreak** · #3 (**permalink**) 24-04-2007, 20:21

$database[dbserver]= this is usually 'localhost';
$database[dbuser]= the username of the user which you have set permissions for to access the database;
$database[dbname]= the name of the database to which you wish to connect;
$database[dbpass]= this should be the password you set for the user which connects to the database;

Edit: Apologies. I did not see the above post when I began typing.

**Shaitan** · #4 (**permalink**) 24-04-2007, 20:59

Hello,

that i all tried...

do I have to put "user_" in front of name and username?

I'm trying to connect to a db I made on Eukhost...

**eUKhost.com** · #5 (**permalink**) 24-04-2007, 21:15

let me know your login username for hostingcontroller. I will get details of exact configuration from our windows system admins.

**Shaitan** · #6 (**permalink**) 25-04-2007, 05:14

My username is lrowlatt

**Shaitan** · #7 (**permalink**) 25-04-2007, 14:16

Why oh why can't I connect to my database :s

access denied for 'user'@'localhost' all the time :s

**hairyfreak** · #8 (**permalink**) 25-04-2007, 17:08

The 'user_' represents the username you use to login to cPanel. This must be appended to the beginning of the username and database you wish to connect with.

If this still does not help, I recommend opening a support ticket with your problem as that seems to be the general recommendation, and the problems seem to rectified very quickly if you do so.

**eUKhost.com** · #9 (**permalink**) 25-04-2007, 20:18

Quote:

Originally Posted by hairyfreak

The 'user_' represents the username you use to login to cPanel. This must be appended to the beginning of the username and database you wish to connect with.

If this still does not help, I recommend opening a support ticket with your problem as that seems to be the general recommendation, and the problems seem to rectified very quickly if you do so.

his account is on a windows server so I am not able to figure out what his database name should be. open a ticket from http://support.eukhost.com and provide me with the ticket number to chase our support people for quick reply.