Pro Zend Framework Techniques: Build a Full CMS Project

Chapter 12. Installing and Managing a Site with Your CMS

In this chapter, I'll cover how to install and manage a site with your CMS.

Creating the Database

The first step to install your CMS on your production server is to create the database. Therefore, create a new database on your server using the MySQL command in Listing 12-1.

Example 12.1. Creating the CMS Database

CREATE DATABASE cms_database

Once you create the database, you need to create a new user for the CMS database using the command in Listing 12-2. On your local server, you may have used the root MySQL user, but this is a critical security risk on a production database. Make sure you make a note of the user's credentials, because you will need to update the CMS configuration file when ...