Verify MySQL data query in Grafana

In this milestone, you verify that your MySQL data source is working correctly by running a test query in Grafana’s Explore feature.

To verify MySQL data in Grafana, complete the following steps:

1. In the Grafana Cloud navigation menu, click Explore.

2. From the data source dropdown at the top-left, select your MySQL data source.

   For example, select Production MySQL Database.

3. In the query editor, enter a simple SQL query to test your connection:

   For example, enter SELECT * FROM performance_schema.file_instances LIMIT 5.

4. Click Run query or press Shift+Enter to execute the query.

5. Verify the query results:

   • You should see the query results displayed in the results panel below the query editor.
   • For more results, change the LIMIT from 5 to 10.

Verify successful data access

After running your test queries, you should see:

• Query results displayed in the Explore interface
• No connection errors or timeouts
• Data that matches what you expect from your MySQL database
• The ability to run different SQL queries successfully

In the final milestone, you’ll celebrate completing this learning journey and explore next steps.