Setting up WordPress with a WebFaction account

I read WordPress' instructions on setting up their blog. WebFaction are a lovely bunch of hosters but it does take a few minutes more than WP claim to get your blog up and running. These are very basic instructions but I couldn't imagine some friends getting through the whole process without a hitch...

Log in to the Webfaction control panel at https://panel.webfaction.com

Go to the domain page (https://panel.webfaction.com/domain/create). This part is telling WebFaction that you plan on using their hosting for a domain name you've just bought

  • Under name, enter the domain eg. "example.com"
  • In the bottom right of the page, click on the page icon with the " + " marker
  • In the subdomain text box, enter "www"
  • Click Create

Again on the control panel's menu, go to "Domains / websites" and then choose Applications.

  • In the bottom right hand, click the Add New icon
  • In the name box enter a name for the application (Something like "my_blog")
  • Under App type, find the WordPress version not marked "insecure"
  • Click create
  • The WordPress application is now installed including a MySQL database to hold your posts.
  • The confirmation page you now see has the password to the database by the Extra info label. Make a note of it somewhere

You now have a WordPress application and a domain for it to use. These two parts need to be linked together under "Domains / websites" > Websites

  • Click to add a new Site, adding the following information:
  • Name: a unique name -  (eg. my_example)
  • Subdomains: add all of the URLs from the list that will point to the new website
  • Under Site apps, add a new entry and choose the name of the application you made earlier (setting the URL path to be "/" if the website will only be a blog)
  • Click Create

Point your web browser now to http://example.com/wp-admin/install.php. You should get a page from WordPress but go to the root URL (http://example.com) and there's an error message:
"Not Found. The requested URL /defaultsite was not found on this server."

To correct this problem, SSH on to your WebFaction account and log in to the MySQL database that was created by the installer (For this command, you'll need the database name which is listed under Databases > "List databases":
mysql -u _your_db_username_  -p

You'll be prompted for the password which you were given after doing the Application part of the setup.

Once you've logged in, use the "show databases;" command to see all of the databases. There should be one named like your application. You need to switch to this DB and then view the tables in this database.
use your_db_username;
show tables;

Something in these tables has some bad data from the initialisation. We're going to delete all of the tables and let the official WordPress setup recreate them properly. Delete each of the tables shown from the previous call using "drop table name_of_table". There are 10 in my blog, each beginning with "wp_". Get rid of them all.

Do "show tables;" again and there should be nothing.

No go back to
http://example.com/wp-admin/install.php

And you should be ready to go.

Choose a name, make a post and example.com should be there with your first post.