Talk:1and1 MySQL installation
I have also succeeded in an initial installation of Moodle on 1and1.com (25 October 2012), though it took a bit of doing. The 2.3 version wouldn't install because 1and1's version of MySQL was not recent enough, so I installed Moodle 2.2.5+. Here are my steps.
I uploaded moodle-latest-22.tgz to my 1and1 directory.
I used SSH to get to a command line and I extracted the files using
- tar -zxvf moodle-latest-22.tgz
I established a moodledata directory. I saved the following line to an .htaccess file in that directory.
- deny from all
To use the latest version of PHP I saved the following line to an .htaccess file in my moodle directory.
- AddHandler x-mapp-php6 .php
In my moodle directory I renamed config-dist.php to config.php. I inserted the following values onto config.php.
$CFG->dbtype = 'mysqli';
$CFG->dbhost = 'db#########.db.1and1.com';
$CFG->dbname = 'db#########';
$CFG->dbuser = 'dbo#########';
$CFG->dbpass = '#####';
$CFG->wwwroot = 'http://myurl.com/moodle';
$CFG->dataroot = '/homepages/7/d#######/htdocs/moodledata';
(Of course, in your installation you would substitute your own values for the hash marks. Most of the info can be garnered easily from phpMyAdmin.)
Then I started the web installation from http://myurl.com/moodle.