Time for action — creating the Mahara database
Let's get on with creating a PostgreSQL database, using your phpPgAdmin panel:
1. Open up your phpPgAdmin panel from your Internet browser and log in. The username is hopefully postgres. Contact your admin if you are unsure of the database password or how to locate the phyPgAdmin panel:
2. On the front page, there is a link that invites you to create a database, click on Create database there. On the resulting screen, give your database a relevant name such as mysite_mahara. It is important that you select the UTF8 collation from the drop-down box. Finally, click on Create:
3. If you want to, you could also add a new user for your database. Use phpPgAdmin to create a new user and assign them permissions for the database you just created.
4. That's it, you're done!
What just happened?
You just created the database for your Mahara installation, using the Open Source phyPgAdmin tool available for Linux.
Another way to create the database on your server is to use the database command-line tool.
Have a go hero — using the command line to create your database
Using the command line is a much more elegant way to create the database, and quicker, once you get the hang of it. Why not have a go at creating the database by using the command line? For instructions on how to do this refer to the database section of the Mahara installation guide at http://wiki.Mahara.org/System_Administrator%27s_Guide/Installing_Mahara.
