Cacti (home)ForumsDocumentation

Install MySQL

MySQL 5.6

  1. Download the latest Generally Available MSI Installer from
  2. Launch the MSI
    1. Agree to the license
    2. Setup Type - Select Server only
    3. Click Execute and wait until the installation has completed.
  3. Click Next to begin the Product Configuration
  4. Type and Networking Page:
    1. Config Type: Server Machine
    2. Connectivity: Leave the defaults selected (TCP, Port 3306, Open Firewall port for network access)
    3. Enable Show Advanced Options
    4. Click Next.
  5. Accounts and Roles Page:
    1. Specify a root password
    2. Skip the User Accounts section
    3. Click Next.
  6. Windows Service Page
    1. Leave all defaults enabled
    2. Click Next.
  7. Apply Server Configuration page
    1. Click Execute.
    2. Validate all steps are green and were successful.
    3. Click Finish
  8. Click Next through the remaining screens.

MySQL 5.5

  1. Download the latest Generally Available MSI Installer from
  2. Install MySQL using the Typical setup.
  3. Launch the MySQL Instance Configuration Wizard
    1. Select Detailed Configuration
    2. Select Server Machine
    3. Select Non-Transactional Database Only
    4. Select Online Transaction Processing (OLTP)
    5. Enable firewall exception for the port
    6. Disable SQL Strict Mode
    7. Select the correct character set for the region.
    8. Select Install As Windows Service
    9. Set a root password
  4. Edit my.ini file. Typically resides in \Program Files\MySQL\MySQL Server X.Y\
  5. Verify sql-mode is not defined. If so, comment it out.
  6. Verify the MySQL service is started.
  7. Set a password for the root user (if not set already during MySQL installation)
    c:\> mysqladmin --user=root password somepassword
    c:\> mysqladmin --user=root --password reload

Configure Database

  1. Create the MySQL database:
    c:\> mysqladmin --user=root --password create cacti
  2. Import the default Cacti database:
    c:\> mysql --user=root --password cacti < C:\Inetpub\wwwroot\cacti\cacti.sql

If you get any errors during this phase, you likely have sql-strict mode enabled or something else misconfigured in my.ini!

  1. Create a MySQL username and password for Cacti.
    c:\> mysql --user=root --password mysql
    mysql> GRANT ALL ON cacti.* TO [email protected] IDENTIFIED BY 'cactipw';
    mysql> flush privileges;

Personal Tools