SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Uploading first database

    Hello!

    I'm in the process of uploading my first site with a database to GoDaddy.com. I managed to get the database up in addition to my site itself. Now if only they would talk to one another! I'm getting the error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)".

    Any help would be appreciated: I feel so close yet so far.

    -Eric

  2. #2
    Non-Member
    Join Date
    Apr 2004
    Location
    Miami, FL, USA
    Posts
    449
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Magento? Are they on the same server? Did you edit Magento's configuration settings to point to the local database? (It's an XML file - I think /etc/config.xml or something). What port are you using? 3306?

  3. #3
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the quick reply!

    I'm not actually using Magento; I wrote the code for everything in the site; but I AM using the Zend Framework (if that helps...). Also, I'm very much a newbie at this and am not sure what "port" I'm using...or even what exactly a port is...

    Further thoughts would be appreciated...

  4. #4
    SitePoint Enthusiast
    Join Date
    Mar 2011
    Posts
    29
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You have to edit the config file and give it the proper parameters like
    database name, database username, database password, database servername etc...

    If all went well, the error will be gone and site will be live or else you might have to ask your hosting support to
    help correcting db error (in most of the cases they won't help but you can try your luck and you might be lucky)

  5. #5
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Thanks so much! Hours of aggravation are gone.

    -Eric

  6. #6
    SitePoint Enthusiast
    Join Date
    Mar 2011
    Posts
    29
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by kreut View Post
    Thanks so much! Hours of aggravation are gone.

    -Eric
    Glad to know, if this small piece of suggestion would have helped you


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •