Book Image

Apache Roller 4.0 - Beginner's Guide

By : Alfonso V. Romero, Brian Fitzpatrick, Alfonso Vidal Romero
Book Image

Apache Roller 4.0 - Beginner's Guide

By: Alfonso V. Romero, Brian Fitzpatrick, Alfonso Vidal Romero

Overview of this book

Apache Roller enables you to build a fully-featured, multi-user blog server apt for all kinds of blogging sites. It is an ideal tool to create your own blogging network with unlimited users and blogs, forums, photo galleries, and more! While it is exciting to have a list of interesting features it can offer you, it might be a little difficult to get started with it by your self. This book will teach you how to get started with Apache Roller and make the most of all its features using step-by-step, detailed instructions. You will learn how to establish your internet presence with an Apache Roller blog and use the latest web tools to enhance your posts and attract visitors. You will also learn how to promote your blog on popular social bookmarking services and customize it to suit your need. This hands-on and practical book introduces you to Apache Roller. Starting off with the configuration and installation of your own blog, you'll then quickly learn how to add interesting content to your blog with the help of plenty of examples. You'll also learn how to change your blog's visual appearance with the help of Roller themes and templates and how to create a community of blogs for you and your colleagues or friends in your Apache Roller blog server. The book also looks at ways you can manage your community, and keep your site safe and secure, ensuring that it is a spam-free, enjoyable community for your users.
Table of Contents (16 chapters)
Apache Roller 4.0
Credits
Foreword
About the Author
About the Reviewers
Preface
Pop Quiz Answers
Index

Time for action — creating a MySQL database for Roller


In this exercise, you'll use the MySQL monitor to create a database for your Apache Roller blog site.

  1. Open a Terminal window (Start | All Programs | Accessories | Command Prompt) and type

    mysql -u root -p

  2. The MySQL monitor will ask you for the "root" user password. This is the password you used when installing MySQL server. Type it and press Enter. If the password is correct, the following screen shall appear:

  3. Now type the following lines after the mysql> prompt (remember to replace password with a secure password) and press Enter after each line:

    create database rollerdb;
    grant all on rollerdb.* to roller_user@'%' identified by 'password';
    grant all on rollerdb.* to roller_user@localhost identified by 'password';
    
  4. When finished, your screen should look like this:

  5. Notice the Query OK, 0 rows affected (X.XX sec) line after each line you typed. It means there were no errors with the commands you entered. Now type exit and press Enter to exit...