Virtual Web Server: Part 7 - WordPress Setup


The Blog of Tom Webster

  2013-05-09 02:24:00 PDT

Now that you have a user and are able to upload files, lets get a WordPress blog going. The first thing to do is download the latest WordPress package, extract it, then upload it via your newly created FTP server. I like FileZilla for FTP work, but any FTP client will work.

Head over to the site, you should see that you need to create a configuration file. If you don't see this, and see an error message instead, make sure you have php5-mysql installed. You can do this with apt-get install php5-mysql then service apache2 restart. For the configuration file, we'll need to first get our database details. This poses somewhat of a problem, though, we don't have a database currently. Log onto your server's root account via SSH, then log onto your MySQL instance with mysql -u root -p and enter your MySQL password (this should be different from your user password). Follow along with the commands below to create a new database and authorizations so we can finish the WordPress setup (all commands should be run from the MySQL command prompt):

Create a new database: CREATE DATABASE exampledatabase;
Create a new MySQL User: GRANT ALL PRIVILEGES ON exampledatabase.* TO "exampleuser"@"localhost" IDENTIFIED BY "MakeAComplexPasswordHere";
Refresh permissions: FLUSH PRIVILEGES
Exit the console: exit

Click Let's go! on the WordPress wizard and fill in the details below:

Database Name: exampledatabase
User Name: exampleuser
Password: YourComplexPasswordHere
Database Host: localhost
Table Prefix: wp_

WordPress should then generate a text box with a lot of configuration data in it. Copy all of this text into a file named wp-config.php, then upload it to the root of your web directory via FTP.

Now your configuration is done, go ahead and proceed with the install. The rest is simple, set up a name for your site, set up a username/password for WordPress, then get on with building cool things. The internet is ripe with WordPress themes, plugins, advice, and examples, do some Googling, figure out what you want to do from here.

Other posts in this series:

  1. Getting a Server
  2. Getting a Domain Name
  3. Automatic Updates
  4. Apache2 Setup
  5. PHP and MySQL Setup
  6. ProFTPd Setup
  7. WordPress Setup - You are here
  8. RVM Setup
  9. Git Setup
  10. OctoPress Setup
  11. Rackspace Backups