🗄️ MySQL
With the database connector add-on and AgencyAnalytics MySQL integration, you can connect directly to your clients' MySQL database and query data, displaying it in widgets alongside other data on dashboards and reports.
Click here to read more about the database connector add-on and how to use database integration widgets.
🔌 Connect MySQL
To avoid a failed connection or error when integrating MySQL within an AgencyAnalytics campaign, the person connecting requires:
Host, Port, User, Password and Database
User entered must have read permissions for the entered database
If the above requirements are met, simply follow these steps to connect:
Open the Campaign where you'd like to connect MySQL
Click Integrations (plug icon) on the left side menu
Search MySQL in the upper right search box, then click the MySQL card
Click the Connect New Account button in the bottom left. If you've previously connected a MySQL instance, click "Connect New Account" at the bottom.
Enter the details for the instance you'd like to connect, then Save in the bottom left.
Your MySQL instance will be displayed in the list of available connections. Click the circle to the left of the instance name, then click Connect in the bottom left to finalize the connection.
Once done, the selected instance will be connected within your campaign, and you can start adding MySQL widgets to your reporting and query data right away!
💬 Need additional help?
If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help 😄