Search
Left Quote    You have to THINK anyway, so why not think BIG?
- Donald Trump    
Right Quote
 
[login] | [Register]
Forum Index » PHP and mySQL » Viewing Topic and Replies
Post Reply


        Viewing Topic: Complete Member System Help
  This user is offline  Smeagol3
  Subject: "Complete Member System Help" Posted: @ 10:11 pm on Apr 29 2008   
Member #: 676
Rank: User - (7)
Since: 04/29/08
Posts: 7

When I register on my site, I click submit and am taken to a page with this:
 my site said...
< i>Can't connect to local MySQL server through socket '/var/run/mysql d/mysqld.sock' (2)< /div>

Am I not able to connect to my database?

Edited at 10:23:08 pm on 04/29/08


    Viewed: 11,411 Times | Reply to This | To top
  This user is offline  Smeagol3
  Subject: "re: Complete Member System Help" Posted: @ 10:44 pm on Apr 29 2008    
Member #: 676
Rank: User - (7)
Since: 04/29/08
Posts: 7

If it helps, this is what my db_connect.php looks like:

Code:

<?php

$database[dbser ver]="loe ffel.accountsup portmysql.com& quot;;
$database[dbuse r]="smeag ol";
$database[dbnam e]="mysit e";
$database[dbpas s]="mypas s";
$table ="members ";

$connect = mysql_connect($ database['dbse rver'], $database['dbu ser'], $database['dbp ass']);

$select= mysql_select_db ($database['db name']);
?>


The username and pass are the ones that I need to use to access phpMyAdmin.

Thanks for any help.

Edit:

I'm pretty sure this is a database connection problem, because if I just run this from my site:

Code:
<?php
mysql_connect( "loeffel.a ccountsupportmy sql.com", "smeagol ", "password " or die(mysql_error ());
echo "Connecte d to MySQL<br />";
?>



I get  my site said...
< i>Unknown MySQL server host 'loeffel.accou ntsupportmysql. com' (1)< /div>



Edited at 11:07:13 pm on 04/29/08


    Viewed: 11,398 Times | Reply to This | To top
  This user is offline  misterhaan
  Subject: "re: Complete Member System Help" Posted: @ 4:08 pm on Apr 30 2008    

Member #: 5
Rank: User - (213)
Since: 02/11/05
Posts: 148
From: chair

it doesn't seem to know what you




please note that the above post is likely made up in its entirety.

    Viewed: 11,377 Times | Reply to This | To top
  This user is offline  Smeagol3
  Subject: "re: Complete Member System Help" Posted: @ 2:43 am on May 01 2008    
Member #: 676
Rank: User - (7)
Since: 04/29/08
Posts: 7

I checked with them, and that is correct. When I tell tech support about my problem, they just tell me to check my username, password, and database URL. My host has been giving me so many problems lately that I'm going to find a new one.




    Viewed: 11,366 Times | Reply to This | To top
  This user is offline  misterhaan
  Subject: "re: Complete Member System Help" Posted: @ 1:58 pm on May 01 2008    

Member #: 5
Rank: User - (213)
Since: 02/11/05
Posts: 148
From: chair

you show them that error and they say it might be a problem with the username or password, but don



Edited at 02:06:54 pm on 05/01/08


please note that the above post is likely made up in its entirety.

    Viewed: 11,355 Times | Reply to This | To top
  This user is offline  Smeagol3
  Subject: "re: Complete Member System Help" Posted: @ 8:52 pm on May 01 2008    
Member #: 676
Rank: User - (7)
Since: 04/29/08
Posts: 7

I've actually looked at dreamhost in my quest for hosting. If I go with them, I'll be sure to use your referral link.

I'm temporarily using a free host, and within 5 minutes I was connected to my database.




    Viewed: 11,351 Times | Reply to This | To top
  This user is offline  Smeagol3
  Subject: "re: Complete Member System Help" Posted: @ 10:19 pm on May 01 2008    
Member #: 676
Rank: User - (7)
Since: 04/29/08
Posts: 7

I have the database working now, and I can insert the member info into the database.

When I register using the registration script provided, I click submit and it just refreshes the page. It doesn't show the success message or add it to my database.




    Viewed: 11,346 Times | Reply to This | To top
  This user is offline  misterhaan
  Subject: "re: Complete Member System Help" Posted: @ 2:27 pm on May 02 2008    

Member #: 5
Rank: User - (213)
Since: 02/11/05
Posts: 148
From: chair

glad you got your database working, and hope you can find a host that meets your needs!

i




please note that the above post is likely made up in its entirety.

    Viewed: 11,332 Times | Reply to This | To top
Viewing Page: 1 of 1


1 |

You must be logged in to post on the forums. Login or Register








"AllSyntax.com" Copyright © 2002-2018; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank