You are currently reviewing an older revision of this page.

DRAFT INT-XXXX Adding a data source in Admin Console fails with Credentials Invalid error

Symptoms

Adding a data source in the Admin Console fails and the following error is witnessed in the MySQL audit logs: 

<site_name> mysql-audit:  <site_name>.saas.appiancloud.com,<username>,172.17.246.94,293076,0,FAILED_CONNECT,,,1044
...
<site_name> mysql-audit:  <site_name>.saas.appiancloud.com,username,172.17.246.94,296846,0,FAILED_CONNECT,,,1045

The following error about invalid credentials is observed on the UI: 

Cause

This issue occurs because the user which is used to connect to the database has insufficient MySQL permissions.

Action

Grant the user sufficient permissions on the database using the MySQL documentation.

Affected Versions

This article applies to all versions of Appian. 

Last Reviewed: April 2019