---
title: Connect MySQL Database to Infoveave
description: Learn how to connect and configure MySQL in Infoveave to query relational data from MySQL databases for dashboards and reports.
---

import { MediaPlayerComponent } from "../../../../../components/video-player";
import RunScript from "../../../../../components/RunScript.astro";
import { Steps } from '@astrojs/starlight/components';

# MySQL

<MediaPlayerComponent
  video="MysqlConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 4,
    "end": 6,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 6,
    "end": 8,
    "text": "Select MySql Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on 'MySQL' to establish a connection to a MySQL database."
  },
  {
    "start": 8,
    "end": 17,
    "text": "Configure MySql Details",
    "description": "In the 'New Connection' dialog box, enter the connection name. Keep the 'Port' as '3306' and the 'Server' as 'localhost.' Provide the 'Username,' enter the corresponding 'Password,' and set the 'Database'."
  },
  {
    "start": 17,
    "end": 20,
    "text": "Validate MySql Connection",
    "description": "Click the 'Validate' button to confirm that the provided MySQL server details and credentials are correct and that Infoveave can successfully connect to the database."
  },
  {
    "start": 20,
    "end": 24,
    "text": "Save MySql Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the connection to your list of available connections."
  }
]
}
  poster="/images/introduction-poster.png"
  posterText="Creating MySql Connection"
  client:load
/>

MySQL connection helps to connect a MySQL database for accessing and managing your relational data directly from Infoveave.

## Adding a MySQL Connection

To create a new MySQL connection:

<Steps>
1. Go to **Administration** > **Connections**
2. Click **New Connection** and select **MySQL** from the available connectors
3. In the **New MySQL Connection** form, provide the required configuration details
</Steps>

## Connection Parameters

When setting up a MySQL connection, you need to provide the following details:

| Field | Description |
|-------|-------------|
| **Name** | A unique name to identify your MySQL connection |
| **Server** | The MySQL Server host address or instance name |
| **Port** | The MySQL Server port (default: 3306) |
| **Username** | Your MySQL authentication username |
| **Password** | Your MySQL authentication password |
| **Database** | The specific database name to connect to |
| **Schema** | The database schema (optional) |

## Steps to Validate and Save

<Steps>
1. After configuring your MySQL connection parameters, click **Validate** to verify the connection
2. If validation succeeds, click **Save** to store the connection
3. You can now use MySQL Server as a datasource in your Infoveave workspace
</Steps>

## Example Use Cases

With a MySQL connection configured, you can:

- Query and analyze relational data directly from MySQL databases
- Create real-time dashboards with data from multiple MySQL tables
- Build automated workflows that trigger on database changes
- Perform complex data joins and transformations using SQL queries
- Schedule regular data extracts from MySQL for reporting and analytics
- Integrate MySQL data with other data sources in Infoveave
- Monitor database performance metrics and query optimization
- Set up data synchronization between MySQL and other systems
- Create advanced analytics using MySQL views and stored procedures
- Generate business intelligence reports from web application data
- Analyze e-commerce data stored in MySQL databases
- Process and visualize content management system data