Cacti (home)ForumsDocumentation

Install MySQL

MySQL 5.6 / 5.7

  1. Download the latest Generally Available MSI Installer from MySQL.com.
  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. Plugins and Extensions
    1. Leave all defaults disabled
    2. Click Next.
  8. Advanced Options
    1. Enable General Log
    2. Enable Slow Query Log
    3. Click Next.
  9. Apply Server Configuration page
    1. Click Execute.
    2. Validate all steps are green and were successful.
    3. Click Finish
  10. Click Next through the remaining screens.

MySQL 5.5

  1. Download the latest Generally Available MSI Installer from MySQL.com.
  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

Install TimeZone Database

  1. Download TimeZone database from: http://dev.mysql.com/downloads/timezones.html
  2. Extract file
  3. Import:
    c:\> mysql --user=root --password mysql < C:\downloads\timezone_posix.sql
  4. Validate it works. The two queries below should return the same result in the form of central US time 2007-03-11 01:00:00
    c:\> mysql --user=root --password mysql
mysql> SELECT CONVERT_TZ('2007-03-11 2:00:00','US/Eastern','US/Central');
  +------------------------------------------------------------+
  | CONVERT_TZ('2007-03-11 2:00:00','US/Eastern','US/Central') |
  +------------------------------------------------------------+
  | 2007-03-11 01:00:00                                        |
  +------------------------------------------------------------+
  1 row in set (0.01 sec)

mysql> SELECT CONVERT_TZ('2007-03-11 3:00:00','US/Eastern','US/Central');
  +------------------------------------------------------------+
  | CONVERT_TZ('2007-03-11 3:00:00','US/Eastern','US/Central') |
  +------------------------------------------------------------+
  | 2007-03-11 01:00:00                                        |
  +------------------------------------------------------------+
  1 row in set (0.00 sec)

Install Cacti 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> GRANT SELECT ON mysql.time_zone_name TO [email protected] IDENTIFIED BY 'cactipw';
mysql> flush privileges;





Personal Tools