You are currently reviewing an older revision of this page.
Adding a data source in admin console fails and the following error is witnessed in MySQL audit logs:
Feb 14 10:51:36 gsuat mysql-audit: gsuat.saas.appiancloud.com,sharedDbUser,172.17.246.94,293076,0,FAILED_CONNECT,,,1044 ... Feb 14 11:04:26 gsuat mysql-audit: gsuat.saas.appiancloud.com,sharedDbUser,172.17.246.94,296846,0,FAILED_CONNECT,,,1045
Following error is observed on the browser:
This issue occurs because the user which is used to connect to the database has insufficient MySQL permissions
Grant the user sufficient permissions on the database using the following commands:
mysql> grant all privileges on Appian.* to '<username>'@'%';
This article applies to all versions of Appian.
Last Reviewed: April 2019