Select a value

MySQL

MySQL is a widely available database, though the specificities for the steps below based on your hosting provider, the concepts remain the same.

1. Create new user credentials

Create a new user for your database. This allows us to create separate and more restrictive permissions for use within Commonality. Take note of the username and password you create in this step, as you'll need it later.

2. Set read-only permissions Grant read-only permissions to the schema or database you want to access within Commonality to the user you just created above. Read-only access prevents users from writing or deleting any important information as they write KPI queries within Commonality.

3. Connect to database

Within Commonality, you can connect to your database either by using a connection string or separately adding all the credentials you created above.