Greetings mortal!

Below you'll find a (small) manual which will explain a few things about the use of phpmyadmin.
This manual has been made by using the following version:

• phpMyAdmin - 2.11.8.1deb5
• MySQL client version: 5.0.51a

As time will tell this manual might grow into something more larger. As for now this manual will only concentrate on the use of phpMyAdmin, not the installation for it!

Before we can begin we will have to browse to the machine (http://IP/phpmyadmin/ also look at the picture to the right) and login to be able to use anything phpmyadmin has to offer. We will use the root user mostly for the creation of new users. For the creation of databases we will use the user with the correct rights.

First, we'll have to login as root. Browse towards your phpmyadmin webpage (usually done by going to http://<ip address/hostname>/phpmyadmin.
Login as root here, giving the username and password.

Next we are going to the page that is called “privileges” (right screen).
This screen will show what users are already present on the system with several key information pieces which could be usefull at some time.

Since we are just adding users we can click on “Add a new User” (screenshot) and enter the next screen again.



Once on this page we will have to fill in several fields: (right screen).

• username: The username used for database access,
• host: Since we are most likely only going to use this user on the same machine as the stats and mysql is hosted, lets just use 'localhost' as only login possibility. If you are planning on seperating the mysql server with the server that holds the website files, set this to 'any',
• password: I usually tend to use the 'Generate' button to generate myself a password. You can then use the 'Copy' button to copy over the generated password to the password fields.
• dd

Pictures:
http://img25.imageshack.us/img25/821/pmausers01.jpg
http://img18.imageshack.us/img18/2638/pmausers02.jpg
http://img9.imageshack.us/img9/2452/pmausers03.jpg
http://img9.imageshack.us/img9/4681/pmausers04.jpg

This chapter will handle the creation of databases and …

N/A for now, will be filled later.

N/A for now, will be filled later.

This chapter is just a placeholder and will be expanded / replaced over time.