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
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.
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
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:
Password: leave it blank
Server of Choice: MySQL
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.
Click on the Add user account link which is circled in red as shown in the photo above.
Database Login Information
- Username: yourusername
- Hostname: localhost
- 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.
- Check the “Create database with same name and grant all privileges”
- Check “Grant all privileges on wildcard name (username\_%)
- Scroll to the bottom and click on the “Go” button which is located at the bottom right of the webpage.
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.