Step 3

You will now be presented with the main menu. On the far left it will give you details of the database selected (at the moment there are none). In the main window you will have two list's one for MySql and one for Php. We will be using the MySql menu.

Step 4

Enter the new database name into the box, then press create.

Step 5

Now click "home" (top left hand corner). Select "users" from the MySql list. In the Add new user section:

click host and enter localhost as the name,

then the required username and password.

Then check the following box's for the privileges:-

select

insert

update

delete

create

drop

index

alter

Then click go

Step 6

Click "home".

Click "reload MySql".

Click "users"

Click "Grants" in the action column at the top of the screen next to the user.

Click "Revoke Privileges" under the action column.

Click "home"

Step 7

Click "users"

Click "Grants" next to the user.

Click "Database" Make sure the privileges are set to: select

insert

update

delete

create

drop

index

alter

Then click go.