How to Install Onpub on Windows

Published: Jul 7, 2010. Updated: Aug 18, 2010.

Follow the steps in this article to install Onpub on Windows using IIS as your web server.

Install Required Software

Onpub requires both MySQL and PHP. We've provided direct download links below for your convenience. Onpub should work "out of the box" with the default installation settings for both MySQL and PHP.

Download the latest stable Windows version of MySQL and install to setup the MySQL database server for Windows.

Download the Microsoft Web Platform Installer and install to setup PHP for IIS.

Download & Extract Onpub

Unzip the latest Onpub .zip download file to the following folder in Windows:

• C:\inetpub\wwwroot

You should now have a folder under the above folder named onpub.

Setup the Onpub Database

Onpub requires a MySQL database to store the websites you will be creating. In order to setup a MySQL database for use with Onpub, do the following:

1. Open the MySQL Command Line Client from Start > All Programs > MySQL > MySQL Server..
2. Enter the MySQL root password (you would have entered this when you installed MySQL)
3. Execute the following command in the MySQL Command Line to create the Onpub database:
   • CREATE DATABASE onpub CHARACTER SET=latin1 COLLATE=latin1_general_ci;
4. Execute the following command (make sure to replace 'user' and 'password' with a username and password of your own choosing) in the MySQL Command Shell to create a MySQL account (you will be using this to log in to the Onpub content management interface):
   • GRANT ALL ON onpub.* TO 'user'@'localhost' IDENTIFIED BY 'password';

Provided the above two MySQL commands were successful, you should now have a MySQL database and account we will be using to complete the Onpub installation.

See this article for more information about setting up a MySQL database for use with Onpub.

Login to Onpub

Open a web browser and type in the following address to load the Onpub login page:

• http://localhost/onpub/manage/index.php

You should see 3 input fields called Database, Username, and Password.

In the Database field enter onpub (or whatever name you chose for your Onpub MySQL database in the previous section).

In the Username and Password fields enter your MySQL account username and password respectively (this would be the username and password you chose for your MySQL account in the previous section).

See this article for more information about how to login to Onpub.

Provided you entered the correct login information, you should now see the Onpub Welcome screen.

Install the Onpub Database Tables

Now that you are logged in to Onpub for the first time, be sure to click the Install missing tables on the Welcome page to install the Onpub schema in to your MySQL database.

If the Onpub tables installed without error, you are now ready to start building websites with Onpub!