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.