Connect MySQL
Depending on where your MySQL server is hosted, you may need to take some additional steps in addition to the ones listed below. For example, on Amazon RDS, you must enable the appropriate security groups and on Google Cloud, you should allow Bigeye's IP address 35.163.65.120
.
1. Create a MySQL read-only user
Bigeye recommends creating 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_name'@'host' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Replace database_name
, user_name
, host
, and password
with your actual values. 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. Alternatively, you can also restrict access to only certain tables in your database.
2. Add MySQL as data source in Bigeye
From the Catalog tab in the sidebar, select Add Source. This will take you to a page where you can configure the connection to your database.

To connect a database, you will need to input the following information:
- Alias - identifying name for this data source
- Vendor - MySQL
- Hostname - name of the server that hosts your database
- Port - 3306
- Database name - your database name
- Username - username of the MySQL read-only user you created previously
- Password - password of the MySQL read-only user you created
- Timeout
Once filled out, the form should look something like this

3. Next Steps
Bigeye will now start loading and profiling your tables. It can take up to 24 hours for the profiling to complete and your autometrics/autothresholds to populate. You can now proceed to deploying autometrics in the Getting Started guide.
Updated 9 months ago