You are currently reviewing an older revision of this page.
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.
1. Check the username and password used to access the database are correct.
2. Grant the user sufficient permissions on the database using the MySQL documentation.
This article applies to all versions of Appian.
Last Reviewed: April 2019