Install WordPress On Ubuntu 12.04 Precise Pangolin

WordPress is a content management system that powers quite a variety of websites, first developed in 2003. In WordPress’s early days, it tended to run only personal blogs and smaller sites. However, the software improved considerably with every version, and it’s adaptable enough to be used for a variety of different sites. WordPress’s big break came in 2009 when popular blogging platform Movable Type changed its licensing terms. Enough Movable Type users were annoyed with the change that they migrated to WordPress, and WordPress is the dominant open-source content management system on the Internet as of this writing.

It’s quite possible to install WordPress on a machine running either the desktop or the server version of Ubuntu 12.04 Precise Pangolin. This makes an excellent environment for testing and experimentation, since you can tweak and experiment to your heart’s desire without rendering your production blog inoperable. If you need to run an internal corporate blog of some kind, hosting WordPress on an Ubuntu box or virtual machine is a cheaper solution than more expensive blogging or collaboration software. Or, if you’re really ambitious (and you can afford the bandwidth), you can host an Internet-accessible WordPress blog out of your apartment.

Let’s begin!

(Note that the Ubuntu repositories now contain a fully automated WordPress installation. However, I believe that installing it by hand yourself has significant value – you’ll not only learn how to set up a LAMP server, but installing step-by-step gives you valuable troubleshooting knowledge later on in case something breaks.)

First, install Ubuntu into your machine of choice. Once Ubuntu is installed and updated, you will need to install five pieces of software: the Apache web server, the MySQL database server version 5.1, PHP version 5, the MySQL module for PHP, and finally the WordPress software itself.

First, install the Apache web server. To install Apache, go to a Terminal window or a command prompt and type this command:

sudo apt-get install apache2

(Technically, you’ll be installing Apache 2, the latest version.)

Enter your password to authenticate, follow the default prompts, and apt will download and install the Apache web server for you.

And that’s it! Apache should now be working. To test it from the web server itself, go to a web browser and visit the address http://127.0.0.1 . Alternatively, you could test it from another computer on the same subnet. For instance, if you installed Apache on a computer with an IP address of 192.168.1.100, you could test it by going to another computer on the same subnet and visiting http://192.168.100 from the web browser.

Regardless, if Apache is working properly, you should see a web page with only two words on it:

It works!

Apache is now operational.

The next step to install WordPress is to install the MySQL database server. Return to the Terminal and type this command:

sudo apt-get install mysql-server-5.5

(As of this writing, MySQL Server version 5.5 is the latest version available in the Ubuntu repositories, though future versions of Ubuntu may receive the newer versions of MySQL.)

Enter your password to authenticate, and apt will download the MySQL files and install them for you. It’s a big set of files, so depending on the speed of your Internet connection, it might take a while to download. After the files are downloaded and are installing, the installer will ask you for a password for MySQL’s root user. Just like the root user in Linux, the root user in MySQL has absolute control over all databases, tables, permissions, and users. For obvious security reasons, you’ll want to create an extremely strong password (a mixture of uppercase, lowercase, numbers, and punctuation, the longer the better) for your MySQL root user.

(Note that in the password dialog box, you can’t get the <OK> field selected, you can use the tab key to jump from the text input line to the <OK> field.)

After you enter the root password, the installer will finish working with the MySQL files, and return you to the command line. You’ll then need to activate MySQL with the following command:

sudo mysql_install_db

This will set up MySQL Server for use with your Ubuntu system. Next, you’ll want to run the mysql_secure_installation script to tighten up security on your new MySQL server. Run this command from the prompt:

sudo mysql_secure_installation

First, the mysql_secure_installation script will ask you to enter the current password for the MySQL root user. After you do that, it will ask if you want to change the root password. Since you already set a root password, you can hit “n” (unless you want to change it again for some reason).

Next, the script will ask if you want to remove the anonymous user. The anonymous user, like anonymous access in FTP, lets someone log into MySQL without having a proper user account. For security reasons, it’s always best to remove the anonymous user, so hit “y” to continue.

After that, the script will ask if you want to prevent the MySQL root user from logging in remotely to the MySQL server. Always hit “y” to forbid root remote access, since if an attacker guesses your root password, he can destroy your databases or steal the information they contain.

After this, the script will ask if you want to remove the test database. MySQL includes a test database that anyone can access. Again, this is a security hole, so you’ll want to hit “y” to remove the test database.

The script will then ask to reload the privilege tables so the changes take effect. Hit “y”, and the mysql_secure_installation script will conclude and return you to the command line.

MySQL server is now installed on your Ubuntu system.

The next step to installing WordPress is to install PHP version 5:

sudo apt-get install php5

Then install the MySQL module for PHP:

sudo apt-get install php5-mysql

You may also want to install the GD library for PHP, since many WordPress plugins rely on it for graphical manipulation:

sudo apt-get install php5-gd

Finally, download the WordPress software to your Desktop. You can obtain it from this address:

http://wordpress.org/latest.tar.gz

If you’re working exclusively from the command line, you can use this command to download the WordPress software:

wget http://wordpress.org/latest.tar.gz

Use this command to unpack the WordPress files:

tar -xzvf latest.tar.gz

Make a directory in /var/www for the WordPress files:

sudo mkdir /var/www/wordpress

Finally, move the WordPress files over to the /var/www/wordpress directory. (In this command, I’ll assume you unpacked the WordPress files to your home directory; you will have to adjust the command if you unpacked them in a different directory.)

sudo cp -r ~/wordpress/* /var/www/wordpress

Now that we’ve got our software installed and downloaded, we’ll need to configure it. We’ll start with Apache.

First, it’s always a good idea to make a backup of a system configuration file before you alter it, so start by making a back of Apache’s configuration file. Use this command to back up Apache’s configuration file to your home directory:

cp /etc/apache2/apache2.conf ~

Next, you’ll need to add a line to your /etc/apache2/apache2.conf file, so Apache will properly interpret WordPress’s PHP files. (Note that this is only necessary if you install WordPress in a subdirectory of /var/www, as we are doing in this example. If you install WordPress in /var/www, you don’t need to add this line, but you do need to delete or move the original index.html file.) To edit apache2.conf, fire up the vi editor:

sudo vi /etc/apache2/apache2.conf

Once you are in vi, scroll to the end of the vile, switch to Insert mode, and add the following line:

AddType application/x-httpd-php .html

Return vi to Command mode, save the file, and then exit vi. Restart Apache with this command, so it re-reads its configuration file:

sudo /etc/init.d/apache2 restart

Now we’ll need to prepare MySQL for use with WordPress. WordPress requires a database and a database user, and full permission for its database user to access its database. To start the MySQL command-line client, use this command:

mysql -u root -p

Enter the password for the MySQL root user, and you’ll find yourself at the MySQL command prompt, which will look like this:

mysql>

Our next steps are to create a WordPress database, create a user to access that database, and grant our new user all rights to the WordPress database.

(An important note before we continue, though. All commands made from the MySQL prompt must end with a semicolon to denote the end of the statement. Any commands that do not end with a semicolon will not work. With that in mind, let’s first create a database.)

To create a database for WordPress, use this command at the mysql> prompt:

CREATE DATABASE wordpress;

The MySQL client will respond with a message that should say “Query OK, 1 row affect (0.00 sec).” This means the command was successful, and a new database named “newdatabase” has been created.

Next, you’ll create a user who will access that database:

CREATE USER wordpressuser;

You should get the “Query OK” message again. Once the new user is created, we’ll need to set a password for the user before we can assign any permissions. In this example, we’ll assign a password of “1234″. However, in real life, just as with the root user, you’ll want to assign a strong password. (This database user won’t have full control over the MySQL user as the root user does, but we will give it full control over the database we just created, and a malicious user who guesses the password could cause all kinds of trouble.)  To create the password, use this command:

SET PASSWORD FOR wordpressuser= PASSWORD(“1234”);

Again you should get the “Query OK” confirmation message. The final step is to assign all privileges on the “wordpress” database to the “wordpressuser” user. Use this command to assign the permissions:

GRANT ALL PRIVILEGES ON wordpress.* TO wordpressuser IDENTIFIED BY ‘1234′;

That isn’t a typo – those are single quote marks (‘) instead of the usual double quote marks (“) that were used in the command to set the password. MySQL’s internal syntax, alas, isn’t always consistent. Anyway, if you typed the command correctly, you should get the “Query OK” confirmation again.

Once you are done, use this command to quit the MySQL command-line interface:

exit

Then type exit to quit the MySQL local command-line client. Now that we have MySQL prepared, we can now configure WordPress itself. Specifically, we’ll have to configure WordPress to talk to the database we just created. To do so, you must create a wp-config.php file in the WordPress directory. Fortunately, WordPress includes a handy wp-config-sample.php you can use as a template.

Type this command to create a wp-config file (assuming you installed WordPress in the www/wordpress directory):

sudo cp /var/www/wordpress/wp-config-sample.php /var/www/wordpress/wp-config.php

Next, use vi to edit the newly created wp-config file:

sudo vi /var/www/wordpress/wp-config.php

You’ll see that the wp-config.php file contains a number of variables. Change the following three variables:

-Change putyourdbnamehere to wordpress.

-Change usernamehere to wordpressuser.

-Change yourpassword here to 1234.

Once you have your changes made (after double-checking the spelling, of course), switch vi to Command mode, and save your changed file.

Everything should now be ready. Open up a web browser, and navigate to http://127.0.0.1/wordpress. (If you want to access it from a different machine, of course, use the IP address of the WordPress server, for instance – http://192.168.1.100/wordpress .)If you configured everything correctly, you should then be greeted by the WordPress configuration page. You’ll pick a username, and WordPress will assign you a password. Follow the prompts, and you will have a functional WordPress blog installed on a Ubuntu machine. Congratulations!

One final note: if you configure your blog from a local browser, it will probably set your blog’s address as http://127.0.0.1/wordpress. This is fine if you only want to view it from the host machine, but if you want to view it over the network, you’ll need to change it. Fortunately, you can do so quickly by going Options in the WordPress admin interface, and then to General, and changing the blog’s URL.

-JM

ADDITIONAL READING:

The Ubuntu Beginner’s Guide

The Ubuntu Desktop Beginner’s Guide.

This entry was posted in Ubuntu 12.04. Bookmark the permalink.

17 Responses to Install WordPress On Ubuntu 12.04 Precise Pangolin

  1. Thank you very much for the guide, it works like a charm!

  2. Devan Phillis says:

    i cannot get this command to go thru
    SET PASSWORD FOR wordpressuser= PASSWORD(“1234”);

  3. Pingback: WordPress Automatic Update not working localhost installation (FIXED)

  4. Marvin Eric Tan says:

    Thank you very much for this! I bookmarked your site.

  5. vinnie says:

    I cant get this command:
    SET PASSWORD FOR wordpressuser= PASSWORD(“1234”);
    to work either! I’m stuck from there…

  6. hoop says:

    for those whom cant get the

    SET PASSWORD FOR wordpressuser= PASSWORD(“1234”);

    command to work:

    its a problem with the “curly quotes” delete the quotes and type them by hand instead of copy-pasting them.

  7. jimj says:

    Nice post. Simple and to the point. Many thanks.

    j

  8. Ashraf says:

    Great Tutorial :D

  9. SET PASSWORD FOR wordpressuser= PASSWORD(“1234”);

    above command has errors.

    give a space after wordpressuser and there is no space between = and PASSWORD

    write like this…
    SET PASSWORD FOR wordpressuser =PASSWORD(“1234”);

  10. Pete says:

    The mysql user create and password add can be done all at once:

    GRANT ALL PRIVILEGES to ‘wordpressuser’@’localhost’ IDENTIFIED by ‘1234’;

    Should create the user at the same time, also good idea to use the wordpress DB:

    USE wordpress;
    FLUSH PRIVILEGES;

    Also if you dont want to have to type /wordpress you can edit the sites-enabled 000-default file to change the document root.

    Great basic instructions though :)

  11. Ethan says:

    when go to /wordpress I get “Error establishing a database connection”, any ideas what I’m missing? I checked everything in the .config file again, looks good. Help! thanks in advance

  12. Pingus says:

    Everything went smooth. It would be great if you write a post on how to install drupal on ubuntu.
    THANKS!!

  13. Robb says:

    @Ethan,

    I get the exact same error message. Additionally the tab on my browser says Database Error. I am a newbie to ubuntu.

  14. Jon-Paul Raymond says:

    I believe you have the following reversed:
    ____________________________________________________
    SET PASSWORD FOR wordpressuser= PASSWORD(“1234”);

    Again you should get the “Query OK” confirmation message. The final step is to assign all privileges on the “wordpress” database to the “wordpressuser” user. Use this command to assign the permissions:

    GRANT ALL PRIVILEGES ON wordpress.* TO wordpressuser IDENTIFIED BY ‘1234′;
    ____________________________________________________

    It did not work the way stated above. To get “QUERY OK” I had to reverse some things:

    For SET PASSWORD i used ‘1234’ not “1234”
    and
    For GRANT ALL PRIVILEGES i used “1234” not ‘1234’

  15. Dan says:

    This tutorial is excellent. Nice one.

  16. Excellent items from you, man. I have bear in mind your stuff previous to and you are simply extremely great. I actually like what you have received right here, certainly like what you are stating and the way wherein you assert it. You are making it entertaining and you continue to take care of to stay it sensible. I can not wait to learn much more from you. That is really a tremendous web site.

  17. Spencer says:

    “Once you have your changes made (after double-checking the spelling, of course), switch vi to Command mode, and save your changed file.”

    I am unable to edit this file. Looks like it does not have write permissions. I made a copy of it to the desktop and was able to edit that OK. I can not copy the edited file over /var/www/wordpress/wp-config.php. Anyone?