KB483161: Connection to Platform Analytics Warehouse Database Fails with Error "Connection Failed."

Description

When creating a Platform Analytics Project, a DSN to the Platform Analytics MySQL database is required on the Intelligence Server machine. However, if you install the out-of-the-box MySQL database on a machine other than the Intelligence Server machine (which is recommended for performance reasons), the DSN fails to be created because the connection to the database fails.
When using Strategy Connectivity Wizard to create a DSN to the out-of-the-box MySQL database and then test the connection to the database, it will fail and the DSN is not created.

Note: This does not apply to customers using their own MySQL DB.

Steps to Reproduce

Environment Configuration

• The out-of-the-box MySQL database only works for environments with one Intelligence server and when Platform Analytics and the out-of-the-box MySQL are installed on the same machine.
• It's recommended to to have an environment with clustered Intelligence servers and/or Platform Analytics and the out-of-the-box MySQL database installed on a machine separate from the Intelligence server. 

Creating the DSN for the Platform Analytics Project

1. Create a new DSN to the out-of-the-box MySQL database on a machine separate from the Intelligence server. The out-of-the-box Platform Analytics DSN does not work for out-of-the-box MySQL databases on any other machine than localhost.
   
2. Use the Connectivity Wizard to create a DSN to the out-of-the-box MySQL database (the MySQL driver must be installed prior to this). The MySQL driver will appear under "Other." Select the Unicode Driver.
3. Provide the host, port, and test the connection with your login credentials:
   
1. Host: the machine with the out-of-the-box MySQL database.
2. Port: 3306.
3. Username: mstr.
4. Password: Found in the express_password file.
4. The test connection fails.

Solution

The test connection fails because the out-of-the-box MySQL database comes with the default user mstr@localhost. Since the out-of-the-box MySQL database is not on localhost (relative to the Intelligence server machine from which the DSN is created), causes the connection to fail because the out-of-the-box MySQL database refuses connections from all other hosts besides localhost.
To resolve this issue, use a MySQL administrator utility to change the mstr user in the out-of-the-box MySQL database from mstr@localhost to mstr@<intelligence-server-machine> or mstr@% for global access. Afterwards, you will be able to successfully create a DSN.
KB483161