1and1 MySQL installation

There are examples of Moodle being successfully installed on 1and1 Apache hosted sites. There are some formalities that you must follow. In the config.php file, you must use the following format for the listed database variables:

$CFG->dbtype    = 'mysql';       // mysql or postgres7 (for now)
$CFG->dbhost    = 'db123.yourdomain.net';   // eg localhost or db.isp.com
$CFG->dbname    = 'db123456789';      // database name, eg moodle
$CFG->dbuser    = 'dbo123456789';    // your database username
$CFG->dbpass    = 'yourpassword';    // your database password
$CFG->prefix    = 'mdl_';        // Prefix to use for all table names

Other variables must be defined as follows:

$CFG->wwwroot   = 'http://www.yourdomain.com';
$CFG->dirroot   = '/homepages/12/d123456789/htdocs/yourdirectory';
$CFG->dataroot  = '/homepages/12/d123456789/htdocs/moodledata';

So far, this gets me into the Moodle setup program on the server, but I get errors when trying to install Moodle. It can't seem to correctly set up the database. Please edit this page to provide more information to the many users of 1and1. Thank you.

---

In my experience you also need to add .htaccess file which contains this line AddType x-mapp-php5 .php to your moodle folder as described in Installation hangs when setting-up database tablesFAQ.