Install CA Executive Insight on Windows › Install CA Executive Insight on Windows › Install MySQL on Windows

Install MySQL on Windows

Note: This installation is only required for a new installation, not an upgrade installation.

CA Executive Insight stores its data in a MySQL database. Before you can install the product, MySQL must be installed. You can install MySQL on the same system as CA Executive Insight or on a remote system.

Note: Before you install MySQL, uninstall any existing installations of MySQL and delete any existing files. See Delete an Older Version of MySQL for more information.

Follow these steps:

1. Double-click mysql-advanced-5.5.8-winx64.msi.

   The Setup Wizard opens.

2. Click Next

   The End-User License Agreement page opens.

3. Accept the license agreement and click Next.

   The Chose Setup Type page opens.

4. Click Complete.

   Note: If you are reinstalling MySQL, click Custom to specify a different install location.

   The Ready to install MySQL Server 5.5 page opens.

5. Click Install.

   The MySQL Enterprise dialog opens.

6. Follow the prompts to start the server instance configuration.

   The Configuration Wizard prompts for a configuration type.

7. Select the Detailed Configuration option button, and click Next.

   The Configuration Wizard prompts for a server type.

8. Select the Develop Machine option button, and click Next.

   The Configuration Wizard prompts for the database usage.

9. Select the Multifunctional Database option button, and click Next.

   The Configuration Wizard prompts for a place to store the InnoDB tablespace.

10. Select \MySQL Datafiles\ from the Installation Path drop-down list, select a drive, and click Next.

    Note: If you reinstall MySQL, remove this directory before rerunning the installer.

    The Configuration Wizard prompts for the number of concurrent connections to the server.

11. Select the Decision Support (DSS)/OLAP option button, and click Next.

    The Configuration Wizard prompts for networking options.

12. Accept the default networking options, and click Next.

    The Configuration Wizard prompts for the default character set.

13. Select the Standard Character Set option button, and click Next.

    The Configuration Wizard prompts for the Windows options.

14. Select the Include Bin Directory in Windows PATH check box, and click Next.

    The Configuration Wizard prompts for the security options.

15. Enter a password in the New root password field. Retype the password in the Confirm field, and click Next.

    The Configuration Wizard prompts to start the configuration.

16. Click Execute.

    The configuration is processed.

17. Click Finish to close the wizard.

    MySQL is installed on Windows. The MySQL service starts automatically.

Important! After you install MySQL, decide whether to update or add the MySQL default configuration, depending on the number of business indicators. For sizing, see Critical CA Executive Insight Sizing Information.