CiviCRM Community Forums (archive)

I'm new at just about everything concerning CiviCRM, Drupal and hosting on a public service... previously hosted a small site on my own server, but minimal... I'm trying to install CiviCRM 4.0 on Drupal 7.9 with MySQL on a Linux hosting account (my own at goDaddy.com)... Following the install instructions, all fine until running the Civi installation.  Then tons of errors... some have been resolved by changing file permissions, but here's what I'm chewing on now:

The Drupal settings.php contains:
$databases = array (
  'default' =>
  array (
    'default' =>
    array (
      'database' => 'lot1134207314897',
      'username' => 'lot1134207314897',
      'password' => 'xxxxxxx',
      'host' => 'lot1134207314897.db.7131341.hostedresource.com',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);

where 'xxxxxx' is my Drupal password.  The strange database name, username and host were generated by Drupal.

here's the URL I used to run the installer:  http://<drupal.lotuslight.us>/sites/all/modules/civicrm/install/index{dot}php  ("lotuslight.us" is my URL; drupal is the subdirectory

I'm getting these errors:

Does the server exist   OK (lot1134207314897.db.7131341.hostedresource.com)
Are the access credentials correct   That username/password doesn't work: Access denied for user 'lot1134207314897'@'97.74.24.136' (using password: YES)
Can I access/create the database   I can't create new databases and the database '' doesn't exist (user 'lot1134207314897' doesn't have CREATE DATABASE permissions.)

I have no idea how to change the access permissions for a username I didn't create...

I'm also puzzled about the entry for "database server"/"host"... does localhost refer to the "site" root directory or was I correct in what I copied from the settings.php file?

Here is what I entered into the installer fields:
CiviCRM Database Settings

MySQL server:    lot1134207314897.db.7131341.hostedresource.com
MySQL username: lot1134207314897
MySQL password: xxxxxxx
MySQL database: lot1134207314897
Drupal Database Settings

MySQL server:    lot1134207314897.db.7131341.hostedresource.com
MySQL username: lot1134207314897
MySQL password: xxxxxx
MySQL database: lot1134207314897

passwords are not x's, but the actual passwords and they match.

What am I missing here?

Thanks for your help...
Saroj