Download, Install, and Configure XAMPP

Introduction

These instructions are for Windows.

During these installation and configuration steps, a database and administration accounts will be created. Be sure to write down the information. It will be used when installing Moodle.

Step 1. Download the XAMPP installer

Dowload the latest installer from here .

Step 2. Follow the XAMPP installation instruction on the website

Install in C:\xampp

Step 3. Configure XAMPP for Moodle

The following steps use the XAMPP console to:

1. Make Apache and MySQL Windows services
2. Create a MySQL database for Moodle
3. Create an administrator account for the Moodle database

Note: The administrator account should only have access to the Moodle database

Step 3.1 Make Apache and MySQL Windows services

Click on the red X and make Apache and MySQL servces.

image missing

Step 3.2 Create a MySQL database for Moodle

MySQL commands from Moodle installation documentation

CREATE DATABASE moodle;
ALTER DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

1. Click on the MySQL Admin button.
2. Select the Databases tab.
3. Enter a name for the database. For example "moodle", or "test", or .....
   (use lowercase to keep it simple)
4. Click on "Create".

image missing

Step 3.3 Create an administrator account for the Moodle database

MySQL command from Moodle installation documentation

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,
DROP,INDEX,ALTER ON moodle.* TO moodleadmin@localhost
IDENTIFIED BY 'password';

1. Select the Database tab.
2. Click on "Check Privileges" for the database.

image missing

3. Select "Add user".

image missing

4. Enter a Username.
5. Select "local".
6. Enter a Password.
7. Grant all privileges on the moodle database.
8. Click on "Add User".

image missing