Table of Contents

Create the Database

Introduction

Xcalibur W supports various popular database engines, including

For the initial Xcalibur W installation, a database and several user accounts with appropriate permissions must be created before starting Xcalibur W.

Refer to the database user manual for information on these processes.

User Accounts

Create two database user accounts:

Assign the following privileges to the accounts:

Note: Some databases assign users' privileges to a specific database or table. In this case, create the database first, and then create/assign the users.

Example :MySQL 

1 CREATE USER 'wpadmin'@'%' IDENTIFIED BY 'password';

Create the Database

Create a database called “wp_manager”, and then assign the “wpadmin” and “wpweb” users to the database.

Example :MySQL 

1 CREATE DATABASE wp_manager;
2 GRANT ALL PRIVILEGES ON wp_manager.* TO 'wpadmin'@'%' WITH GRANT OPTION;
3 FLUSH PRIVILEGES;

Using a client application compatible with your database engine, verify that all accounts can connect to the database, and that the wpadmin user can create tables within the database.

Client application list:

When the steps above are complete, you are ready to configure Xcalibur W Server to connect to your database.

Connection String

Depending on the database in use, define the connection string (login/password/host:port/schema) as shown below:

First Launch of Xcalibur W Server

For the first launch and for maintenance operations (updates, etc.), temporarily re-allocate the connection string from the wpweb account to the wpadmin account. Then, restart the web server and/or the web site.