By ycc on

Hi,

I'm new with Drupal so please advice me on anything, including posting in this forum :)

I am trying to move my small Drupal installation from my own server to GoDaddy. On my Ubuntu/Linux 7.04 Apache2, Drupal worked immediately. I just had to remove the file ".htaccess", otherwise the installscript wouldn't start. Thanks for fantastic software!

I have created a MySQL database at GoDaddy and uploaded my Drupal database into it. I can reach it through phpMyAdmin. As I understand the name of the DATABASE and the name of the database USER is the same at GoDaddy.

I have expanded (from the compressed file) a new set of Drupal-5.2 files into a folder on my disk and uploaded it.

As you all know better than I, the final step of the Drupal installation is to run the install script. The install script starts and runs and I enter the following data into the script:

Database Name: drupal_yl
Database User Name: drupal_yl
pwd: <my password>

(The combined "User name" and "Database Name" I use at GoDaddy is obviously "drupal_yl" :)

However, I get the following error message from the Drupal installation script:

The following error must be resolved before you can continue the installation process:
Failure to connect to your MySQL database server. MySQL reports the following message: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2).

I am very greatful for advice. Why cannot Drupal connect to the database? It is possible to connect to the database through phpMyAdmin.

I tried the GoDaddy support line but they don't consider themselves responsible for third party sortware. :(

Thanks a lot :)

⋅ Categories: Drupal 5.x

Comments

arzajac’s picture

arzajac commented

GoDaddy runs it's database on seperate servers. By default, Drupal assumes it's "localhost".

In your Godaddy account, you will be able to pull up the mysql settings (under Action, click the little pen icon (edit/view details) ). Find the mysql server Host name. Open the advanced tab in your drupal installation page and paste the database server name there.

That's it.

ycc’s picture

ycc commented

@arzajac Thanks for a very clear reply. I just can't try it out right now though. GoDaddy servers seem overloaded? I'll be back later and report the result ;)

ycc’s picture

ycc commented

@arzajac Could finally test it. It worked exactly as you said, of course. (Also temporarily toggling the $access_check variable in update.php, as advised by the error message.) I'm almost completely new to Drupal but it is really pleasant to use. Thanks.

stevemagg’s picture

stevemagg commented

yo.

sunnyq’s picture

sunnyq commented

Thanks Arzajac! That's exactly what I needed, too!