In Part 1 of this article I walked through (and provided a video for) the downloading of the server software to be setup on a PC (or USB drive or what have you). Let me continue on here with the rest of the steps for running WordPress offline.

USB web server console

Read Part 1 Here

What Are the Buttons on the USBWebServer Home Screen?

You will see 4 buttons on the home screen for USBWebServer. The bottom button will bring you the web site where you downloaded the software so that you can look at a manual, some FAQs, make a donation, etc.

The top button, Root dir will simply open the “root” folder where the web site files are installed. This is where you would export the WordPress files to, making sure to delete the existing files that are in there first. The Settings tab on the right will let you change the default path for “root” if desired.

Note: by default, the Settings tab may not be in English. It may say Instellingen. If you want to change it to English, click the tab, change the Taal setting to English, and click the Opslaan button to save the setting.

Now, back to the General tab. The next button that says Localhost will surf to the “root” folder but from a web browser. This way, rather than look at a set of files like when clicking Root dir we are looking at the web site iterpreted by the browser, in all of it’s aesthetics and dynamicism.

Lastly, we have the phpMyAdmin button on the main screen of USBWebServer. That will undoubtedly launch phpMyAdmin. The default username and password is “root” and “usbw” respectively. That will also be the account that gains access to the MySQL database which we will configure for use with WordPress.

Creating a New Database in phpMyAdmin

Upon launching phpMyAdmin, click on the Databases tab from across the top. It’s the first one. You will see that there is a default empty database there called “test.” We can easily use that for our WordPress install.

As long as we know:

  • a) the database name (“test”)
  • b) the database user name and password (“root” and “usbw”)
  • c) the host name (“localhost”)

… then we have enough information to install WordPress.

Of course, we have to be sure that “root” has “all priveleges” to the database, which as you can probably guess, it does by default.

If you wanted to create a brand new database, just enter a name for it in the Create a new database box at the top, then click the Create button. You could choose “utf8_general_ci” under the Collation drop box first if desired.

That’s all there is to creating the database. It will have all priveleges by default. The host will again be “localhost” and “root” can be used as the user for the DB in the WordPress config.

Installing WordPress is the Same Here as Any Server Just About

Now, with the “web server” setup, the “root folder” established, and the empty MySQL database created, we now just need to:

  • a) download the WordPress files and extract them
  • b) change the WordPress config file
  • c) put the extracted files into the root folder
  • d) launch the site by clicking the Localhost button to complete the installation

The rest of the process here is straight forward. You just setup WordPress as you normally would. Of course, you won’t have the luxury of Fantastico with this default setup but it’s still very easy.

Really it just involves unzipping the WordPress files downloaded from WordPress.org into the root folder. Then after launching the site you can plugin the values for the database when prompted and WordPress will create the config file for you.

Now, you have an offline version of WordPress installed and you have the ability to test/demo your WordPress site locally.

Remember that when/if it comes time to bringing the site online you will need to change the WordPress Address and Site Address URLs to reflect the domain/path being used online.