468x60-2
Setting up a new database locally using WampServer and PhpMyAdmin

In this tutorial I'm going to show you how to add a new database to your own mini-server (WampServer) on localhost using PhpMyAdmin. PhpMyAdmin is used by most hosting companies so what you learn here you can use on your web host as well.

Alright so let's get started. Once you start your PhpMyAdmin application with the WampServer tray icon menu, you will see two possible ways to make a new MySQL database:

Like it is shown on the screenshot above, you can add a new database by selecting the Databases button from the top menu which will take you to the database table where you can see all the databases that you currently have on your server. The second method is adding a new database in the Actions > MySQL localhost area by writting in your database name and pressing the Create button.

For the purpose of this tutorial, we are going to take the first and longer way of doing it. Go ahead and click on the Databases button in the top menu to get the database table:

Here you can see all your databases and edit their permissions by clicking on the lock icon in the row next to it. You can also delete any of your databases by selecting the boxes in front of them and clicking the small red "X" icon located right from the "Check All / Uncheck All" text.

The box at the bottom is used to add new databases so go ahead and write in a database name and press the Create button. My database name is going to be "batcave_db" since I already have batman as a user ;-)

After entering the database name and pressing the button you will get a confirmation box that your database has been added and you will be able to select it from the database drop down menu on the left side of the interface. It is also going to say "no tables found in database" because it has just been created and is empty.

Now that we created our new database, we can go back to the PhpMyAdmin homepage and see if it appears on the list with the other databases.

We see the database is there. Now you can add tables to your database or just use it for a Content Management System or a forum installation.

Another thing you are going to need is to know how to add a user to your database which you can learn how to do by check out our Setting up a new database locally using WampServer and PhpMyAdmin tutorial.

 

Databases

Web Design

You are here  : Home Colorimetry Setting up a new database locally using WampServer and PhpMyAdmin

Most Read Content

Social Networking

Bookmark and Share

Check out The Knowledge Reactor on your favorite social networking websites and help us spread the knowledge!