{"id":1561,"date":"2016-04-29T12:42:46","date_gmt":"2016-04-29T19:42:46","guid":{"rendered":"http:\/\/internetofhomethings.com\/homethings\/?p=1561"},"modified":"2016-04-29T14:58:55","modified_gmt":"2016-04-29T21:58:55","slug":"usb-lamp-web-server-part-5-wordpress","status":"publish","type":"post","link":"https:\/\/internetofhomethings.com\/homethings\/?p=1561","title":{"rendered":"USB LAMP Web Server Part 5 – WordPress"},"content":{"rendered":"

\"wordpress_icon\"<\/a><\/p>\n

Alas we come to the final installment of this 5-part series. Last but not least, let’s install WordPress on our private USB-based LAMP server. And in case you just joined us, here is a link<\/a> to the first part, which also provides references\u00a0to all the other pieces to this puzzle.<\/p>\n

WordPress is the most widely used Content Management System (CMS) used today. As of April, 2016, 22% of all new website use WordPress. With all the options available today, that\u00a0is impressive market penetration!<\/p>\n

Major Shortcut!!!<\/strong><\/h2>\n

And, just like with my last post, for those who do not want to go through all the setup steps, a Linux session save file is included with this post.<\/p>\n

Simply replace your existing save file with this one and you will be 99% complete with a web server that supports both php and mySQL server. Here it is<\/a>.<\/p>\n

Now let’s get to the step-by-step instructions…<\/p>\n

Adding WordPress\u00a0to the USB Web\u00a0Server<\/strong><\/h3>\n

Step 1:\u00a0Installing the WordPress Package.<\/strong><\/p>\n

Start the USB installed Precision Puppy Linux from part 4<\/a>. Then launch the Puppy Package Manager. In the search window (Find), enter “wordpress” and search all repositories.<\/p>\n

Select wordpress_3.3.1 (or higher revision if available).<\/p>\n

Then click “Examine dependencies” \u00a0 and “Download and install selected packages”.<\/p>\n

Now close and restart the\u00a0Puppy Package Manager. In the search window (Find), enter “php5-gd” and search all repositories.<\/p>\n

Select php5-gd_5.3.10 (or higher revision if available)<\/p>\n

If the Description says “ALREADY INSTALLED”, then quit Puppy Package Manager
\nand continue to the next step.<\/p>\n

Otherwise, click “Examine dependencies” \u00a0 and “Download and install selected packages”.<\/span><\/p>\n

Step 2: Create a WordPress Database and user in mySQL.<\/strong><\/p>\n

Start the mySQL server and open 2 console windows.<\/p>\n

In the first windows, start the mySQL server by entering (adjust IP to your conversion):<\/p>\n

#\u00a0mysqld –bind-address 192.168.0.11<\/p>\n

In the second widow, start the Apache Server by entering:<\/p>\n

# \/etc\/init.d\/apache2 restart<\/p>\n

On\u00a0another computer on the same network as the LAMP server, enter the following in a web browser:<\/p>\n

http:\/\/192.168.0.11:9777\/phpmyadmin\/<\/p>\n


\n<\/a>\"wordpress_mysql1\"<\/a><\/p>\n

Use the Username “root” with no password and click “Go” to enter phpMyAdmin, the mySQL database administration tool installed in part 4<\/a> of this series of USB LAMP server articles.<\/p>\n

From the page that is now displayed, click on the databases tab.<\/p>\n

\"wordpress_mysql2\"<\/a><\/p>\n

Now lets create a database called “wordpress” to check out our installation. \u00a0Enter “wordpress” for the database name and click “Create”:<\/p>\n

\"wordpress_mysql3\"<\/a><\/p>\n

The new database will appear in the list of databases. We are now going to link\u00a0a\u00a0user to this database. Click “Check Privileges”.<\/p>\n

\"wordpress_mysql4\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

Then click “Add a new user”.<\/p>\n

\"wordpress_mysql5\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Enter “demowpuser” in the “User name”, “Password”, and “Re-type” fields. Then click “Go” at the bottom of this page.<\/p>\n

\"wordpress_mysql6\"<\/a><\/p>\n

This demo WordPress database setup is now complete.<\/p>\n

Step 3: Get the WordPress files.<\/strong><\/p>\n

The WordPress files can be downloaded either from a separate computer or the USB LAMP server. Assuming you are using the USB LAMP server:<\/p>\n

Open the Puppy Linux Web Browser by clicking on the “browse” icon on the desktop. Then got to the URL: https:\/wordpress.org\/download.<\/p>\n

Click “Download WordPress”.<\/p>\n

Save the zip file to “\/mnt\/home”.<\/p>\n

Using the Pupply Linux file Manager (Menu>Filesystem>ROX-Filer file manager), navigate to “\/mnt\/home” and click on the WordPress zip file that was downloaded.<\/p>\n

Right-click on the “wordpress” folder and select “Extract”.<\/p>\n

\"wordpress_zipfile\"<\/a><\/p>\n

Enter “\/var\/www” as the “Directory to extract to”.<\/p>\n

\"wordpress_extract\"<\/a><\/p>\n

Click “OK”.<\/p>\n

Step 4: Setup the WordPress Configuration<\/strong><\/p>\n

Using the\u00a0ROX-Filer file manager, navigate to “\/var\/www\/wordpress”.<\/p>\n

Open the file “wp-config-sample.php” (right-click on it and select “Open as Text”).<\/p>\n

Find the section that contains:
\n
\n\/\/ ** MySQL settings - You can get this info from your web host ** \/\/
\n\/** The name of the database for WordPress *\/
\ndefine('DB_NAME', 'database_name_here');<\/code><\/p>\n

\/** MySQL database username *\/
\ndefine(‘DB_USER’, ‘username_here’);<\/p>\n

\/** MySQL database password *\/
\ndefine(‘DB_PASSWORD’, ‘password_here’);<\/p>\n

Change it to:
\n
\n\/\/ ** MySQL settings - You can get this info from your web host ** \/\/
\n\/** The name of the database for WordPress *\/
\ndefine('DB_NAME', 'wordpress');<\/code><\/p>\n

\/** MySQL database username *\/
\ndefine(‘DB_USER’, ‘demowpuser’);<\/p>\n

\/** MySQL database password *\/
\ndefine(‘DB_PASSWORD’, ‘demowpuser’);
\nSave the file as wp-config.php and exit the file<\/p>\n

\"wordpress_config\"<\/a><\/p>\n

Step 5: Set folder permissions<\/strong><\/p>\n

Open a console window and enter:<\/p>\n

# chmod -R o777 \/var\/www\/wordpress<\/p>\n

Step 6: Setting up your installation<\/strong><\/p>\n

Start your mySQL database and Apache servers:<\/p>\n