Connecting to a MySQL Database

👤 This documentation is intended for Site Administrators and/or Database Administrators.

Prior to connecting a MySQL Database, follow the platform specific instructions on whitelisting Sisense's IPs.

MySQL databases identify users by the username and IP the user is accessing the database from. As such, if there is a certain user database, whitelist IPs within MySQL by doing:

GRANT SELECT ON my_database.* TO 'sisense'@'%';

In place of the '%' which is a wildcard character that allows connections for the Sisense user from anywhere, the user can instead substitute for the two Sisense IPs, or the IP of the SSH box if Sisense is accessing the MySQL database through an SSH tunnel.

Finally, follow the instructions on granting table permissions so that Sisense can query tables.