[dchaffey]

I am trying to get my new shopping cart on line. I am hitting a wall. Below is the current error. I have tried my domain name, server and I.P address where it asks:

// Hostname or ip of server
$servername="xxxxxxxxxx";

Here is the error I am getting:

Warning: mysql_connect(): Unknown MySQL Server Host 'xxxxxxxxxxxxx'
(1) in /home/xxxxxxx/public_html/sunshop/admin/db_mysql.php on line 44

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/xxxxxxx/public_html/sunshop/admin/db_mysql.php on line 49
Connect Failed: Cant make connection to database.

Error number: Unknown

Error description: None

Please ensure that the database and server is correctly configured and try again.

Any help would be appreciated.

Thanks

[TweezerMan]

Welcome to the forums, dchaffey!

Assuming you're running the shopping cart on a TCH-hosted account, the proper value for $servername is "localhost".

[dchaffey]

TCH-David, on Jul 23 2005, 09:12 PM, said:

Welcome to the forums, dchaffey! 

Assuming you're running the shopping cart on a TCH-hosted account, the proper value for $servername is "localhost".

<{POST_SNAPBACK}>

Thanks for the suggestion, I tried that, too. I am supposed to be on server10. I
tried entering that and did not work either. Any other thoughts?

[TCH-Don]

Be sure that in MySql you

1 - created the database
2 - created a user
3 -added the user to the database


Then to connect to the database in a script use:

host: localhost
database: yourCpanelName_databaseName
user: yourCpanelName_databaseUser
password: mypassword

* Note password is just as the password,
do not add the CpanelName to it.

[TCH-Bruce]

Welcome to the forums, dchaffey

[TCH-Thomas]

Welcome to the forum, dchaffey.

[dchaffey]

Hi Guys,

Thanks for all of the suggestions. I have tried everything I can think of. I will include what I can and see if anyone can make sense of it.

// Hostname or ip of server
$servername="localhost";
// Username and password to log onto db server
$dbusername="XXXXX"; I have tried the database & Cpanel username
$dbpassword="XXXXX"; I have tried the database & Cpanel password
// Name of database
$dbname="sunshop";
// Table prefixes. Do not change the value after the install has been finished!
//$dbprefix="ss_"; // Uncomment this line if this is a new install.
?>

I am getting this error message:

Connect Failed: Unexpected error from the database.

Error number:

Error description:

Please ensure that the database and server is correctly configured and try again

I deleted everything in the MySQL and started over. Any Ideas???

David

[GroovyFish]

Are you sure you added the user to the database?

Its a little unclear how you entered the information (and Don noted this all above)

dbusername would be cpanelusername_databaseusername
dbname would be cpanelusername_databasename
dbpassword would be JUST the password for the database

This post has been edited by GroovyFish: 26 July 2005 - 09:03 PM

[dchaffey]

GroovyFish, on Jul 26 2005, 09:59 PM, said:

Are you sure you added the user to the database?

Its a little unclear how you entered the information (and Don noted this all above)

dbusername would be cpanelusername_databaseusername
dbname would be cpanelusername_databasename
dbpassword would be JUST the password for the database

<{POST_SNAPBACK}>

Thanks GroovyFish,

I did not combine the cpanel and datbase username & password. I will give that a try.

David

[TCH-Rob]

Welcome to the forums, dchaffey

[GroovyFish]

Quote

I did not combine the cpanel and datbase username & password. I will give that a try.
David

<{POST_SNAPBACK}>

David,

I am sure you just typed that wrong, but to be sure, the database password is not a combination, its ONLY the database password. Only the database username and database name are combined with the cpanelusername.

Hope you get it working!

[erisande]

Hello!

I hope I can help. I assume you have a database already created...

In your CPanel, click MySQL Databases. (The attachment shows the lower part of the screen displayed.)
In the Users section, enter a username and password, then click Add User.

When the processing ends, go back to the same screen and select the User and DB from the drop down list (as shown at the top of this attachment), give all privs. For now, all privs is ok for testing, but you may want to change things later on.

Then your SQL code on your page should be something like:

$connection = mysql_pconnect("localhost","USERNAME","PASSWORD")
or die ("Couldn't connect to server.");
$db = mysql_select_db("DATABASE_NAME", $connection)
or die("Couldn't select database.");

Ok, note: USERNAME must match the username exactly as it appeared in the drop down lists. It will look something like:
[account]_[usernameyouentered]
as will the DATABASE_NAME:
[account]_[databasename]

So for example:
USERNAME = myweb_cooluser
DATABASE_NAME = myweb_niftydb

I hope this helps some.

[dchaffey]

erisande, on Jul 28 2005, 11:30 AM, said:

Hello!

I hope I can help. I assume you have a database already created...

In your CPanel, click MySQL Databases. (The attachment shows the lower part of the screen displayed.)
In the Users section, enter a username and password, then click Add User.

When the processing ends, go back to the same screen and select the User and DB from the drop down list (as shown at the top of this attachment), give all privs. For now, all privs is ok for testing, but you may want to change things later on.

Then your SQL code on your page should be something like:

$connection = mysql_pconnect("localhost","USERNAME","PASSWORD")
or die ("Couldn't connect to server.");
$db = mysql_select_db("DATABASE_NAME", $connection)
or die("Couldn't select database.");

Ok, note: USERNAME must match the username exactly as it appeared in the drop down lists. It will look something like:
  [account]_[usernameyouentered]
as will the DATABASE_NAME:
  [account]_[databasename]

So for example:
  USERNAME = myweb_cooluser
  DATABASE_NAME = myweb_niftydb

I hope this helps some.

<{POST_SNAPBACK}>

Thank you for your input. I tried deleating everything and starting over. I still get to the same place. I will give it one more try.

[TCH-Don]

Please look at my post above and tell me at what point it does not work.

[dchaffey]

Thanks for all of your input. I pieced it all together from the input from you-all and re-ran everything. It is working!!!!!!!!

[TCH-Rob]

Glad to see you got it going.

[TCH-Don]

Glad to hear.