How to create and manage database on WampServer?

WampServer helps us set up web development environment on Windows computers. If you like to create and test web applications with Apache and PHP, WampServer is the ideal solution. It is easy to setup and use. If your site is database driven, how can you create a database on WAMP Server? Drupal, WordPress, Joomla, Ghost, osCommerce and many other web apps need a database to store data. See this guide to install WordPress on WAMP Server. A database is almost inevitable. WampServer also comes with phpMyAdmin to create and manage MySQL databases. In this guide, we will show you the basics about how you can create a new WampServer MySQL database using phpMyAdmin, how to back up database and so on.

wampserver logo

How to access phpMyAdmin & databases in WAMPServer?

Run WAMPServer on your PC, it will start all required services automatically and you will see its icon in the notification area at the bottom right corner. When WAMPServer has started all the required services, its icon will turn green and you will be able to visit the home page of your local site by visiting localhost using a web browser. At the bottom left corner of the WAMPServer home page, you should find the Tools category and phpmyadmin link. Click on phpmyadmin, you will open the WampServer database management login page. Alternatively, you can also visit http://localhost/phpmyadmin/ link from browser to log on the database management panel.

phpmyadmin mysql database management tool

What’s phpMyAdmin username and password in WampServer?

Generally, the WampServer phpMyAdmin Username is “root” with no password. To log on WampServer phpMyAdmin as the super user to setup, edit, backup or restore database, you can input root in the Username field, and leave the Password field empty, then click the Go button.

How to create a WampServer database?

The database creating via phpMyAdmin is easy. With just couple of clicks, a new MySQL database can be created. For more details, you can refer to following step-by-step tutorial to create a MySQL database in phpMyAdmin. During the database creating process, you can set the database user and password. You can use these information to establish connection to the database and make a connection between the application and the database.

How to backup WampServer database?

phpMyAdmin makes database backup a piece of cake. See how to backup database in phpMyAdmin here.

That’s all the basics you need to know about WAMPserver database configuration via phpMyAdmin. Should you have any other inquiries, feel free to let us know in the comment section below.

One comment

  1. Hy! we are using wamp server on our linux machine. we are facing a problem, someone is running his files/applications by pasting his files in our apache2 server,by illegal entering into our apache2 server. Due to this, our CPU utilization increasing. please! tell us how to resolve this issue!. thanks

Leave a Reply