1. Open a browser and go to http://localhost and click on the phpmyadmin link at the bottom left of the Server Configuration screen, under Tools.
   

   

2. After phpMyAdmin launches, you can create a new database with the same name as your live site has or will have when you set it up on your web server.
3. Click on the database tab.
4. Name the database something meaningful to you, but not obvious to others to help prevent your site from being hacked.

Note: Sometimes a webhost will give your database a prefix name automatically. On some hosts, you can change this, but on others you cannot. If you can't change the prefix, make sure you either create your database using your webhosts' default prefix in the name or you create a database on your live server first. This way, both the local and live copies have the same name. This will make it easier to keep your files in sync.

Add Your Username and Password for Database Access

1. Now click on the name of the database you just created.
2. Click on the tab named “Privileges”. This page shows the names of all users who have privileges to access that database.
3. Under the section named “New”, click “Add user”
4. Add the username and other details that you will use to access your database as shown below. Clicking "check all" under Global Privileges will select all options.