Cacti W2K3 2 – Configuring The MySQL Database

Cacti W2K3 2 – Configuring The MySQL Database

Introduction

The following article explains how to configure the Cacti MySQL Server 5.5.19 database running on Windows 2003 Standard Edition Server.

The environment used for this installation was a Windows 2003 Standard Edition Server Virtual machine attached to an Active Directory Domain and running under a VMware ESXi 4.0 host.

Creating The Cacti Database

To create the Cacti Database perform the following steps :-

  • Logon to the server as an Administrative account
  • Click on Start, Programs, MySQL, MySQL Server 5.5, MySQL 5.5 Command Line
  • When prompted enter the password configured for the root account
  • To create the database execute the following command :-

create database cacti;

  • Open a command prompt and execute the following command to import the default Cacti database

mysql –user=root –password cacti < “C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\cacti\cacti.sql”

  • When prompted enter the password configured for the root account

Create The Cacti Database User

To create the Cacti Database User perform the following steps :-

  • Logon to the server as an Administrative account
  • Click on Start, Programs, MySQL, MySQL Server 5.5, MySQL 5.5 Command Line
  • When prompted enter the password configured for the root account
  • To create the cacti database user execute the following commands :-

GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY ‘{Your Password}’;

flush privileges;