Grafana is an open-source analytics and interactive visualization web application
that allows users to ingest data from various sources, query this data, and display it on customizable charts for easy analysis.
To begin, set up Grafana by following one of the methods outlined in the Grafana Installation Documentation.Once Grafana is successfully set up in your environment, navigate to the Connections section, click on Add new connection, and select the MySQL plugin
, as shown below.
Now it’s time to fill in the connection details.
There are three options, as below.
You can connect to your local MindsDB. To do that, please use the connection details below:
Copy
Ask AI
Host: `127.0.0.1:47335`Username: `mindsdb`Password: <leave it empty>Database: <leave it empty>
To verify the functionality of our MindsDB database connection,
you can query data in the Explore view. Use the text edit mode to compose your queries.
Whitelist MindsDB Cloud IP addressIf you need to whitelist the MindsDB Cloud IP address to gain access to your
database, reach out to the MindsDB team, and we’ll share the MindsDB Cloud
static IP address with you.
Now that you are all set, we recommend you check out our Tutorials and
Community Tutorials sections, where you’ll find various examples of
regression, classification, and time series predictions with MindsDB.To learn more about MindsDB itself, follow the guide on
MindsDB database structure. Also, don’t miss out on the
remaining pages from the SQL API section, as they explain a common SQL
syntax with examples.Have fun!