Create+a+MySQL+Database+for+Moodle

=Create a MySQL Database for Moodle=

With Webmin now installed, we have an easy way to create a MySQL database that is the key to how Moodle works. Without the MySQL database, no data would be stored in Moodle.

1. Login to your server via Webmin.

2. On the left side of the screen, click "//Servers//," then "//MySQL Database Server//."

3. Under "//MySQL Databases//" click "//Create a new database.//"

4. Give your database a new and click "Create." I call my database "moodle." Once created it will show up in your list of databases.

5. Now we need to create a database user that will edit and manage this database. This information will be important later when we go to configure our Moodle server. Click the "User Permissions" icon.

6. Select "//Create new user.//"

7. Set a name, password and select all permissions by clicking the first choice, scrolling down to the last and holding SHIFT and clicking on the last choice. Then click "//Save//."

8. You should now see your newly created user. So now you have a database and a user to manage that database.

With these steps completed, we are now ready to begin "Downloading Moodle."