login information for creating database in WampServer using phpMyAdmin

Creating a database in WampServer using phpMyAdmin

On my previous post on developing website on local computer running Windows operating system, I promised to write a separate tutorial on creating website in WampServer using phpMyAdmin. So, here you go.

Creating a database for your web development or any web application nowadays very easy. In CPanel, you have the installation wizards that guide you through the steps required in doing so.

How about doing it in local development? Let’s find out.

Creating a Database in WampServer using phpMyAdmin in less than 5 minutes

Before we start, I would like to mention that we are going to use MySQL as our database software. In WampServer, it also offers MariDB as it second server of choice. For your information, the steps are alomst identical.

Step 1: Launching up phpMyAdmin using WampServer

taskbar-wampserver

When you have initiated the WampServer, click on the Green WampServer icon. Another pop-up or dialog box open as seen in the photo below.

creating database in wampserver using phpmyadmin

Referring to the photo above, click on the phpMyAdmin and a web browser will open up. The webpage will point to http://localhost/phpmyadmin/.

Step 2: Creating Database using phpMyAdmin

login to phpMyAdmin

You will be directed to the login page of phpMyAdmin. Now, most of you will not know what is the credential for username and password on the login. Do not worry, please use the credentials stated below in order to login to MySQL in phpMyAdmin:

Username: root

Password: leave it blank

Server of Choice: MySQL

creating database in wampserver using phpmyadmin

When you have successfully login, the above image shows the homepage of the phpMyAdmin. To start creating a database in WampServer using phpMyAdmin, I prefer to directly clicking on User accounts link. This link will enable you to create a user for the database.

add user account

Click on the Add user account link which is circled in red as shown in the photo above.

Database Login Information

login information for creating database in WampServer using phpMyAdmin

  1. Username: yourusername
  2. Hostname: localhost
  3. Password: yourpassword

Please do not change the rest of the information. Just let it be.

Add privileges in creating database in WampServer using phpMyAdmin

The bottom part of the page is where you can add privileges of the user to the database that your going to create in WampServer using phpMyAdmin.

database for user account

  1. Check the “Create database with same name and grant all privileges”
  2. Check “Grant all privileges on wildcard name (username\_%)
  3. Scroll to the bottom and click on the “Go” button which is located at the bottom right of the webpage.

added privileges to user

Voila! You have successfully creating a database in WampServer using phpMyAdmin. Pretty easy, doesn’t it. At the left corner of the page is the list of databases that you have. Make sure that the database you created is listed there.

Now, you can extract any content management system package in the WWW directory and install your website using the database and the user you have just created.

2

No Responses

Write a response