1. Extract the MySQL zip file to a temp directory and run “setup.exe”.
2. Install MySQL to the default directory, or for the purposes of this manual to the “c:\mysql” directory.
3. If running an older version of MySQL, start it by running “c:\mysql\bin\winmysqladmin.exe”. In more recent versions, this is not required.
4. Stop the MySQL service.
5. Edit your C:\MySQL\my.ini file
6. Verify you don't have a sql-mode defined. If so, comment it out.
7. You will need to apply the old client hack for user authentication to work with Cacti.
   1. Add the following to the [mysqld] sub-section:

      #Use old password encryption method (needed for 4.0 and older clients).
      old-passwords

8. Start the MySQL service.
9. 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

10. Create the MySQL database:

    c:\> mysqladmin --user=root --password create cacti

11. Import the default Cacti database:

    c:\> mysql --user=root --password cacti < c:\apache2\htdocs\cacti\cacti.sql

Note: 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 cactiuser@localhost IDENTIFIED BY 'cactipw';
   mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('cactipw') WHERE Host = 'localhost' AND User = 'cactiuser';
   mysql> flush privileges;