Skip to main content

Setting Up a MySQL Instance for Code Insight

The database administrator needs to perform the following steps to set up the MySQL database for Code Insight.

To set up the MySQL database for Code Insight, do the following:

  1. Install the MySQL instance.

    • You might need to configure certain settings once the installation is complete.
    note

    Installing the instance on a machine other than the one on which the Code Insight Core Server is installed might cause performance degradation.

  2. Create a database schema (with a recommended name of codeinsight) and a database user who has appropriate privileges to install Code Insight and whom Code Insight will use internally to manage the database. At a minimum, this user requires the following permissions: ALTER, DROP, CREATE, DELETE, INDEX, INSERT, and UPDATE. The procedure described in Sample Procedure for Creating an Appropriate Database Schema and User can be used to perform these tasks.

  3. Configure the instance as described in Required MySQL Database Settings and Binary Logging Option for MySQL