Get started: 2. Prepare database details

Previous: Get started: 1. Download and prepare code | Next: Get started: 3. Install the website

In your browser go to web page

http://localhost/phpmyadmin/
and log in using a database user, which can manage other users and databases (usually root or admin user).

Create a separated database user for your website (in this example we will use username "dbUser4Manuals" and password "dbPw4Manuals").
Click "User accounts" (tab in upper horizontal menu)!

"Add user account" (link in section New)...

Fill out the user form fields ...
User name: (Use text field) dbUser4Manuals
Password: (Local) dbPw4Manuals
Re-type: (Use text field) dbPw4Manuals

Scroll down and click button Go.

New user was created.

Create database for your website:
Click tab Databases!
Write the database name (in our case amc_manuals) and choose utf8_general_ci from drop-down menu next to database name field and click button Create.

In the next steps give to the created user proper permissions (privileges), so that this user can access the website's database.

First click home icon!

Click "User accounts" (tab in upper horizontal menu)!

Click "Edit privileges" (in row for user dbUser4Manuals)!

Click "Database" (a button under upper menu)!
Select database amc_manuals from "Add privileges on the following database(s):"
click Go!

In Data section tick: SELECT, INSERT, UPDATE, DELETE.
In Structure section tick: CREATE, ALTER, INDEX, DROP.
Scroll down and click button Go.

Check the result:
Similar as described above click following links, tabs, buttons ...
User accounts > Edit privileges (in row of user dbUser4Manuals) > Database
Section "Database-specific privileges" should now show, that database amc\manuals has privileges SELECT, INSERT,UPDATE, DELETE,CREATE, DROP,INDEX, ALTER.

After checking the user privileges log out from phpMyAdmin clicking on door icon with green arrow.

Previous: Get started: 1. Download and prepare code | Next: Get started: 3. Install the website
Get started tutorials
Get started: 1. Download and prepare code
Get started: 2. Prepare database details
Get started: 3. Install the website
Get started: 4. Other useful documentation