Schema Creation

The schema should be created using the following command:

CREATE DATABASE insight DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

Schema User

Xpress Insight expects to fully manage the schema supplied to it. This capability requires a user which has been granted all privileges on the schema.

The schema user should be created using the following command:

CREATE USER 'insight'@'localhost' IDENTIFIED BY 'myPasswordHere';
GRANT ALL ON insight.* TO 'insight'@'localhost';

Note: Use @'localhost' if MySQL and Xpress Insight are hosted on the same machine. Otherwise you need to either identify the host or use '%' to mean all hosts.

If communication between Insight and the database is to be encrypted using SSL then this database user should also be configured to require SSL. To configure the user you have created to require SSL using the following statement:

ALTER USER 'insight'@'localhost' REQUIRE SSL;

For more on SSL, see the later section on Configuring a Secure Connection.

© 2001-2022 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.