If your database is on Amazon RDS, please visit the RDS setup documentation to first enable Chartio in your security groups before following these steps.
MySQL read-only user
Chartio requires a read-only user for connecting to your database. Here is a sample GRANT statement for creating a read-only user:
GRANT SELECT, SHOW VIEW ON $database_name.* TO $user@`22.214.171.124` IDENTIFIED BY '$password'; FLUSH PRIVILEGES;
Where $database_name, $user, and $password are described in the Chartio connection form. Copy this command and paste it into a MySQL shell to create the user. This will grant the user read-only access to ALL tables in your database. If you would like to restrict access to only certain tables in your database, please see Chartio’s help center.
MySQL SSL Connection
Instructions on creating a certificate and SSL connection can be found in the MySQL SSL connection documentation.