fields and click "Add User".
4. Now use the "Add User to Database" button to give this new user account "ALL"
rights to the new database.
5. Note that the username and database names may be prefixed by your Cpanel
account name. When entering this information into the Moodle installer use the full
If you have access to Unix command lines then you can do the same sort of thing by
typing commands. Here are some example Unix command lines for MySQL:
# mysql u root p
> CREATE DATABASE moodle;
> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER ON
TO moodleuser@localhost IDENTIFIED BY yourpassword ;
# mysqladmin p reload
And some example command lines for PostgreSQL:
# su postgres
> psql c "create user moodleuser createdb;" template1
> psql c "create database moodle;" U moodleuser template1
> psql c "alter user moodleuser nocreatedb;" template1
Step 2: Create a Data Directory
Moodle will also need some space on your server s hard disk to store uploaded files, such
as course documents, user pictures and uploads. The Moodle installer tries hard to create
this directory for you but if it fails then you will have to create a directory for this purpose
For security, it s best that this directory is NOT accessible directly via the web. The easiest
way to do this is to simply locate it OUTSIDE the web directory, but if you must have it in
the web directory then protect it by creating a file in the data directory called .htaccess,
containing this line:
deny from all
To make sure that Moodle can save uploaded files in this directory, check that the web
server software (e.g. Apache) has permission to read, write and execute in this directory.
On Unix machines, this means setting the owner of the directory to be something like
"nobody" or "apache", and then giving that user read, write and execute permissions
(777). On Cpanel systems you can use the "File Manager" to find the folder, click on it,
then choose "Change Permissions".
On many shared hosting servers, you will probably need to restrict all file access to your
"group" (to prevent other web host customers from looking at or changing your files), but
provide full read/write access to everyone else (which will allow the web server to access
your files). Speak to your server administrator if you are having trouble setting this up
securely. In particular some sites that use a PHP feature known as "Safe Mode" may
require the administrator to create this directory properly for you.
Step 3: Run The Installer Script
To run the installer script (install.php), just try to access
your Moodle main URL using a web browser, or
(The Installer will try to set a session cookie. If you get
a popup warning in your browser make sure you
accept that cookie!). The first installation setup screen
(Fig. 82) will prompt you for a default site language.