Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
So, now you're ready to create the database for WordPress and set up the general site. Creating a database is a snap with phpMyAdmin, a component of both MAMP and WAMP server. So, let's open up phpMyAdmin--because I'm on a Mac I'm using MAMP--and let me bring that window to the front, and then click Open start page. If you're using WampServer on Windows, you'll need to go to the system tray, left click on the WampServer icon, and then choose phpMyAdmin from there.
In either case, you'll be able to access phpMyAdmin right from your default browser. With MAMP we have a number of options. So, to get to phpMyAdmin, I'll just click it from the tab navigation up top. You could also just put in localhost/MAMP and get the same start page here. So, now we need to create a new database. If you're using an older version of phpMyAdmin, you'll go directly to the database page. With newer versions, you'll need to click on the Database's tab first.
So, click into the Create database field, and enter in the name of the database. For us, it's going to be roux_blog. Now, press Tab to lock that in and then click Create. You'll get a message that the database roux_blog has been created. There's no need for us to create any tables at this point. WordPress is going to put in all the tables we need during the installation process. I do want to point out that if you're following along with the exercise files, then make sure that you use the same name that I used here, roux_blog.
If you don't do that, the exercise files won't work properly. Now, if you already had a site developed and stored in a different folder, you bring that into your local web server root folder, and that's exactly what we're going to do with our exercise files. I'll hide my browser as well as MAMP. And then let's open up exercise files, and go into Chapter 1/01_02, and there you'll see a folder called roux_academy. This has all of the files for the standard website we're going to be working with except the WordPress files.
So, let's copy that, and I'll copy it by right clicking on it and then choosing Copy roux_academy. Now the eventual goal is to put our WordPress files in the local site and whatever folder is used by the Web Server as the localhost root. So, we're going to set up those site files first. Now, your localhost root is different for Mac and Windows. With MAMP on the Mac, that will be in the Applications folder, and then we drill down to MAMP, and there you'll see the htdocs folder. That's the localhost root folder for MAMP.
On Windows under WAMPServer, you'd find that on your C-Drive under WAMP/www. All right. I have my localsite root folder selected, htdocs, and let's go ahead and Paste in our copied folder. Now let's try that out in the browser. I'll open up a new tab, and I'm just going to enter in the full URL just so you see everything, http://localhost/roux_academy/.
Now, in most modern browsers you don't have to enter in the http://, you can just put in localhost, but just so you see the entire thing. And then we'll hit Return, and there's our website, running under the local web Server MAMP. Now that we have our database created and our basic site set up, everything is prepped to integrate the WordPress files.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.