KB-1924 Adding a data source in the Admin Console fails with an invalid credentials error

Symptoms

Adding a data source in the Admin Console fails due to invalid credentials/permissions 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 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

Check that the username and password used to access the database are correct.
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