1. Open a browser and go to http://localhost and click on the phpmyadmin link at the bottom left of the Server Configuration screen, under Tools.

  2. After phpMyAdmin launches, you can create a new database with the same name as your live site has or will have when you set it up on your web server.
  3. Click on the database tab.
  4. Name the database something meaningful to you, but not obvious to others to help prevent your site from being hacked.
Click the “create” button. You'll get a yellow confirmation box that lets you know that the database was created.



Note: Sometimes a webhost will give your database a prefix name automatically. On some hosts, you can change this, but on others you cannot. If you can't change the prefix, make sure you either create your database using your webhosts' default prefix in the name or you create a database on your live server first. This way, both the local and live copies have the same name. This will make it easier to keep your files in sync.

Add Your Username and Password for Database Access

  1. Now click on the name of the database you just created.
  2. Click on the tab named “Privileges”. This page shows the names of all users who have privileges to access that database.
  3. Under the section named “New”, click “Add user”
  4. Add the username and other details that you will use to access your database as shown below. Clicking "check all" under Global Privileges will select all options.



Join the Discussion
Write something…
Recent messages
Bryce W Premium
Very nice training. It helped a great deal.
Reply
I successfully went through both of your tutorials on setting up WAMP and getting the database and my first WP installation on. Everything is go! I have been in the back office of the installation! I will have a duplicate of the site I now have online but all of my work will now be done offline. When I am ready to update anything, I can now do that. I won't have anymore connection problems trying to work on my campaigns. I will create a database for every installation I put on there. That will be the three most important campaigns I have, WA, of course, being one of them.

This is the next best thing since Google Drive!

Very good tutorials! I went through them with no problems.
Reply
Hawaiianeye Premium
Okay..maybe you can show me how it's done?
Reply
I've been out of town. Sorry I didn't get this right away.

It's been six years since I used WAMP and only marginal at best (just able to get it to work) since I have been in this tutorial. I really wish I could help you but I'd have to go through this tutorial again myself.

I just checked on the person who wrote this tutorial and she is no longer here.

Just a quick heads up here, you can go to YouTube or look through the Internet for tutorials on WAMP. I found this video right off the bat. Don't know how good it is but I hope I was of some assistance to you here.

https://youtu.be/W1i44VmrIWY

WAMP was popular amongst the members here for a short time back in the early 2010s and I don't see any activity with this these days on here.
Reply
kendamon Premium
Thanks, this is great information. I have built websites on my local drive using HTML but I never realized it is so easy to create a WordPress site. I can't wait to try it out.
Reply
fishing Premium
Thanks Angelle it does help....
Reply
fishing Premium
I have been trying to download and I get this when I get so far that I am missing MSVCR100.dll is missing from your computer have you any idea what this is??? nice tutorial easy to understand just this comes up and shoots me down....help...
Reply
angelle Premium
I Googled it and found out that it's the Microsoft Visual C++ 2010 Redistributable Package. It's required to run applications developed with Visual C++ on a computer that does not have Visual C++ 2010 installed. You can download the dll from the Microsoft site and install it on your computer. You'll find it here: http://bit.ly/Q7yqNW

You'll just need to pick the one that is compatible with your operating system. My guess is that you'll need either the first or the second one in the list. The first one is the 64bit version and the second one is the 32 bit version. Hope this helps!
Reply
Top