Configuring a Database

Code Insight 6.14.2

To configure a database for Code Insight, perform the following steps.

To configure a database:

1.

Use an existing database or create a new database and schema for use by Code Insight. Make sure your user has the right privileges to access the schema.

2.

Ensure that the schema name conforms to the following guidelines:

•

The first character of the database name is alphabetic.

•

The database name only contains alphanumeric characters or the following special characters: _ $ #.

•

Do not use dashes (-) in the database schema name.

3.

Ensure that the database server is configured to accept connections from the client instances that Code Insight is using (both Core Server and Scan Servers). For example, in MySQL with a database user named Code Insight, this can be accomplished with the following command.

GRANT ALL PRIVILEGES on *.* to 'CodeInsight'@'%' with GRANT OPTION;

4.

Ensure you select the correct character set (UTF-8) and storage engine (InnoDB).

5.

To check if you have the correct character set, use the following database command.

SHOW VARIABLES LIKE 'character%';

6.

Make sure the character_set_database has utf8 in the Value column.

7.

To check if you have InnoDB set up, use the following database command.

SHOW ENGINES;

8.

The InnoDB row should show YES or DEFAULT in the Support column.