In order to connect to a MySQL database, you will need a user account in MySQL with permissions to access your data. Then, in the app, enter the host, port, database, user and password to let Steep connect to your database.
This is the URL for your database.
The default port for MySQL.
Setting up a user account in MySQL
We recommend that you create a new user and role specifically for Steep. This is best done by connecting to your MySQL database using the mysql client or your database client of choice. See below for a step-by-step guide.
1. Create user and grant access
Example SQL script below. Please replace all <brackets> with your details.
-- Create user CREATE USER steep IDENTIFIED BY '<unique-password>'; GRANT SELECT ON <database>.* TO steep;
2. Enter credentials in Steep
Copy the user and password to the corresponding fields in the database form in Steep. Test the connection to make sure things are working fine.