Path To Database

[georgemarshall]

I'm installing a script and have to modify a file.

 

It asks for "a name which uniquely identifies the host server for your database, example: localhost".

 

Any ideas what it would be for me?

 

Thanks,

 

George

[snipe]

Honestly, probably localhost

 

But your cpanel area should tell you all that stuff.

[MikeJ]

Indeed, the path to your databases is always "localhost" on the TCH servers since all of your databases run on the same host as your web account.

[georgemarshall]

Wow! Thanks for the fast response both of you.

 

George

[borfast]

George, first of all, welcome to the family!

 

Second, get used to this kind of quickness, because it's what you'll always get from our family forums

[georgemarshall]

Thanks Raul,

 

I know already how quick TCH support is but was amazed the forum was so quick too.

 

I've hit a new problem

 

Warning: mysql_pconnect(): Unknown MySQL Server Host 'DBSERVERHOST' (1) in /home/mydomain/public_html/phpyellow/installTestDBConnect.php on line 49

 

Failed to establish a database connection.

 

Unknown MySQL Server Host 'DBSERVERHOST' (1)

 

And it asks me to:

 

double check your /* Database connectivity */ values.

 

I had to edit the file as follows:

 

("DBNAME", "XXXX"); /* a name which uniquely identifies your own database, example: phpyellow */

define("DBUSERNAME", "XXX"); /* a name created by mysql for a mysql user of your database, example: root */

define("DBPASSWORD", "XXX"); /* a word created by mysql associated with a mysql user of your database, example: password */

define("DBSERVERHOST", "localhost"); /* a name which uniquely identifies the host server for your database, example: localhost */

 

Which bit refers to database connectivity?

 

George

[TCH-Don]

George! unofficial welcome!

when you post in introductions, you get the official welcome

 

most fail to connect to database is the name used,

be sure to use cpanelname_databasename

and cpanelname_username

 

look in cpanel at MySql to see a suggested string to use to connect with for each data base,

there you will see the the database name and user name for each database.

 

 

hope this helps.

[georgemarshall]

Thanks for your help Don,

 

I double checked my values and they seemed okay.

 

Then today I was installing another php script to another website (a newbie script person who is a glutton for punishment) and I noted the upload in binary or it won't work message.

 

Tried uploading the first script in binary and it's working!

 

Thanks again everyone,

 

George

[borfast]

Glad you managed to get it working

 

If you need any other help, you know where to post

Edited April 5, 2004 by TCH-Raul