Create a database for WordPress on your local PC using Wamp

Raisse

Here I will show you how to create a database for WordPress on your local computer using Wamp server. To create a database, the method is little different from the host server. We can create a database with the help of phpMyAdmin of Wamp server, it is a graphical interface of Wamp to manage or create Mysql database. The local server environment is mostly used by developers or designers for developing or designing a website before doing it live.

Now follow the step by step tutorial to create a database for WordPress.

Step 1) To create a database for WordPress you need to configure local server environment on your PC. So you need to install Wamp for this purpose.

What is Wamp?

WAMP is a short name of Windows, Apache, MySQL, PHP. It is a small server package. You can install on your local PC for testing purpose. It is free and easy to use.

1.1) It is good if it is already installed on your PC. If not then download it from wampserver.com and install it on your Windows PC. I hope you know the installation process.

1.2) After installing Wamp, start it from your Windows start menu.

1.3) When you will click on the start Wamp server, You will see the Wamp server icon on the right side of the taskbar near the clock.

Step 2) Now from here we can create a database for WordPress, click on Wamp icon, it will show you a list of services, click on phpMyAdmin. A phpMyAdmin will open in your default browser. You can also open phpMyAdmin by typing "http://localhost/phpmyadmin" on the browser.

Step 3) You will see a graphical interface like below and a text box.

3.1) Enter the name of the database for WordPress in the given box "Create new database".

3.2) Then click on "create" button.

3.3) After clicking on create button, phpMyAdmin will show you a page of your WordPress database. Here you will find WordPress database name, database host/server, but it will not show you any tables/data of the database.

Note: We don't create the tables in the WordPress database from here. It will be created by the WordPress installation wizard.

Step 4) To run installation wizard, you need to copy your WordPress files in C:/wamp/www/ in windows operating system.

4.1) Create a folder with the name "WordPress" or whatever name you want and move WordPress files inside this folder (C:/wamp/www/wordpress/).

Step 5) Now opens a WordPress installation wizard in browser by typing http://localhost/wordpress. It will show you a message that wp-config.php file is not available and need to create it.

Click on Create configuration file to create the file.

Step 6) On the next page, just click on Let's go.

You need to follow same steps I have explained in my other post How to install WordPress on your host.

The difference is the username and password of the database, here for Wamp server the default username of the database is root and leave the password blank.

Step 7) So the details on the next page are:

Database Name: Enter the name of the database you have created in the previous step, mine is databasename.

User Name: root

Password: leave it blank

Database Host: localhost

Table prefix: leave it default

Then click on submit.

Step 8) After this step, the configuration file has been created. Now you will get a page to run the installation. Click on "Run the install".

Step 9) Again, you will get a welcome page, here you have to enter the details for your website like a title for your site, admin username, admin password and email of the admin.

Then click on Install WordPress.

The Wizard will run the installation and create database tables.

Step 10) Open http://localhost/phpmyadmin in your browser and look at the database you will see the 11 tables in the database "databasename" or whatever database name you have given for your WordPress.