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:
This issue occurs because the user which is used to connect to the database has insufficient MySQL permissions.
This article applies to all versions of Appian.
Last Reviewed: April 2019
© 2020 Appian. All rights reserved.