By retrodans on

I am currently having trouble connecting my site to the database. I created the site on a dreamhost server, but the client would like it hosted on 1&1. So I moved it all across. The files are there fine, and if I connect to my dreamhost server, it all connects just fine, as soon as I attempt to connect to the DB on 1&1 I get a site offline error with:

The mysqli error was: Can't connect to MySQL server on '127.0.0.1' (111).

I am not sure where to fix this, I fear it is to do with the hostname I am asked to use, as it requires a socket. I can connect just fine if I use a generic DB connection, but not Drupal. I have the info below, if it's of any use:

Host name    localhost:/tmp/mysql5.sock
Port    3316

Any help would be very useful, thankyou ever so much, I have been pulling my hair out for days.
Dan

⋅ Categories: Drupal 6.x

Comments

jm9’s picture

jm9 commented

The solutions in this thread may be helpful:

"Problems after hosting moved to Managed Server (MySQL 5.0 issue)"
http://drupal.org/node/404578

JM

www.shopmaker.co.uk’s picture

www.shopmaker.co.uk commented

I have found that the MySQL servers on this host are very slow for database heavy systems.
Not sure how database intensive Drupal is but certainly for our Shop Maker systems, which aren't very heavy, load times were at a snails pace.
I hope you find a solution.