SOLVED 1&1 Drupal 7: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

By michaellenahan on 11 Oct 2011 at 13:12 UTC

Hello, I got the following error when installing Drupal 7 on 1&1 (1and1) shared hosting.

Failed to connect to your database server. The server reports the following message: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).

The solution was to go to Advanced Options - Database host on the Drupal "Set up database" page.

Replace localhost with the host name provided by 1&1 in Control Panel > Database Settings.

I thought I would document it in case this is useful for someone else out there.

Comments

Thanks, worked with Godaddy also

johnlaine commented 25 October 2011 at 03:51

Had the same error message on Godaddy and this was the fix.
Just to clarify for others:
In your settings.php file change the database setting 'host' from 'local' to whatever your hosting provider calls it.
Thanks again!

Confirm - it worked in GoDaddy

aadmi commented 15 December 2011 at 19:21

I had the same error. By adding 'host' as provided by godaddy in Hosting Control Center for the database from 'local' resolved the problem.

Thank you.

on GoDaddy

enidsera commented 31 October 2013 at 02:46

thanks for the fix

Worked for ipage.com too

haebooty commented 27 December 2013 at 19:40

I had this same error and a hell of time reinstalling my site after transfering hosts so gave up and tried just a new install and received this error.

Changing in advanced options for the host to "WEBSITENAME.ipagemysql.com", as indicated under their sql page solved this.

Getting an error:#2002

siteorganizer commented 18 November 2011 at 07:56

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
What do you mean by Advanced Options?

Thank You! Worked for me!

ZeJimmeh commented 25 November 2011 at 00:15

Thank You!

Worked for me!

GoDaddy

korte40 commented 1 April 2012 at 21:33

If you get this error during installation using a GoDaddy hosting account you'll need to go to the 'advanced settings' at the bottom of the Drupal installation page and:

> paste the MySQL server name you get from your GoDaddy account (for example it'll look like this: data1db.db.4496066.hostedresource.com).

> Overall, everything about the Drupal install is very logical. There are no hidden meanings to what Drupal is asking except for this part if you have GoDaddy hosting account. (Linux hosting that is).

I've changed the database

Hagar72 commented 21 April 2012 at 22:40

I've changed the database host from "localhost" to "127.0.0.1" and it works fine for me

It Work

fikifir commented 14 February 2018 at 17:36

After install uninstalling for about 5 times, finally.
thanks.

Thank You!

Jemik commented 4 May 2018 at 08:13

Thank You!

Slick

1q84 commented 19 July 2012 at 02:27

Fixing this was my very first Drupal breakthrough, Thanks michaellenahan!

thanks

fraxinus commented 27 July 2012 at 16:12

@Korte40
This error message had stumped me for ages when trying to install D7 on shared hosting. Delighted to report that your advice worked for me.

Worked for me also

p_rooster commented 17 August 2012 at 21:40

Yes by scrolling down to the Advanced Options I was able to put in the actual hostname of the server (DNS Name) and away it went!

Networksolutions / ip

Alfgabo commented 31 August 2012 at 04:46

When installing on Network Solutions shared hosting it worked for me also, using the server's ip, instead of "localhost"
Thank you

Not seeing where you change the local host setting

rafael1diaz commented 1 May 2013 at 03:04

Hmmm I'm installing Drupal 7.2.2 (Network Solutions) and at the database setup screen the only thing I see under advanced options is:
Database file *
The default entry is: sites/default/files/.ht.sqlite

the text underneath is:"The absolute path to the file where Drupal data will be stored. This must be writable by the web server and should exist outside of the web root."

I don't have an option to change the database hostname or server address.

Am I missing something?

GREAT!!!

Chinelo commented 6 February 2013 at 13:14

Thanks for this saved me alot of time !!!! Problem solved !!

dotCloud

dbusarow commented 9 February 2013 at 17:18

This works for dotCloud too.
Whoda thunk that localhost wouldn't work.

Thanks!
Dan

Thanks!

thelustginslanger commented 17 February 2013 at 14:23

Worked for me as well. Thank you!

In case you wonder why...

markosaurus commented 18 March 2013 at 15:58

It's probably because the hosting provider doesn't have an alias in place from 127.0.0.1 to localhost. (It's an industry standard address, so not sure why they wouldn't?)

So if you replace "localhost" with "127.0.0.1" you're essentially just taking out the reliance on the missing alias, hence fixing the issue.

Another thanks

smallcoder commented 11 November 2013 at 13:03

Had this problem with a new VPS server and this solved it straight away. Many thanks - lifesaver !

You can probably fix this yourself...

markosaurus commented 19 November 2013 at 16:20

If it's a VPS then you can probably fix this by looking into your DNS if you have time.

Thanks

viola_chisto commented 14 February 2014 at 16:51

I did it and it's works perfectly. Thanks

byethost

DynV commented 9 July 2014 at 04:54

Thanks a lot! On byethost (from BYET Internet Services), one can see the host name in cPanel X (vistapanel) home page (with in the left sidebar the section Stats, Account Details & Server Information) in the section Databases (in main section) clicking MySQL Databases lead to a page labeled MySQL Databases, in the section Current Databases there's a table which should have the DB name in the column MySQL DB Name, the corresponding column (of the same row) MySQL Host Name contain what should replace the default localhost. Mine was sql300.byethost6.com.