> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect your MySQL Database to Google Sheets

> Move your MySQL data to Google Sheets with ease! This guide connects them in just a few clicks - no coding needed.

Superjoin has revolutionized the way organizations connect to MySQL databases, offering secure and efficient connection solutions. This guide will walk you through setting up a connection with Superjoin, ensuring you can leverage the full capabilities of Superjoin with your MySQL database. 🚀

## Step-by-step walkthrough: How to connect MySQL to Google Sheets

<iframe width="560" height="415" src="https://www.youtube.com/embed/m5muhl6xODY?si=sCls35CJ_KIsYhjc" title="Pull data from MySQL to Google Sheets" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowFullScreen style={{ width: "100%", borderRadius: "0.5rem" }} />

<Steps titleSize="h2">
  <Step title="Launch Superjoin">
    Once Superjoin is installed, navigate to the `Extensions` menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.

    <Frame>
      <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/launchstackit.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=14e2ecb541402cb914b79951a8faff16" width="1347" height="543" data-path="images/launchstackit.png" />
    </Frame>
  </Step>

  <Step title="Pick MySQL">
    Select MySQL from the list of available data sources.

    <Frame>
      <img src="https://mintcdn.com/superjoin/95T8cmea616drJuC/images/mysql/ms-step2.webp?fit=max&auto=format&n=95T8cmea616drJuC&q=85&s=5137dae9dc53eb1d88167b978e1ec98c" width="1821" height="870" data-path="images/mysql/ms-step2.webp" />
    </Frame>
  </Step>

  <Step title="Connect your MySQL Database">
    Enter your connection credentials.

    <Warning>
      Avoid using local IP address (127.0.0.1) or private IP addresses like 192.168.1.100 (192.168.X.X). A private IP address for a server is like a private address of your device in a home or office network which can only be accessed from within the network and not from outside.
    </Warning>

    <Note>
      Typically, you can find these details in the configuration files of the application that interacts with your database, such as a config.php, .env, or other server-side configuration files. Alternatively, you may access these details from your database management system like phpMyAdmin or directly through MySQL command line using the status command.
    </Note>

    | Field    | Description                                                             | Example                |
    | -------- | ----------------------------------------------------------------------- | ---------------------- |
    | Host     | Enter the path to your database, which could be a URL or an IP address. | mydatabase.example.com |
    | Port     | Use the specific port for your MySQL database.                          | Default is 3306        |
    | Database | Specify the name of the database you want to query.                     | mydatabase             |
    | User     | Enter the username for connecting to your MySQL database.               | admin or user123       |
    | Password | Provide the password corresponding to the specified user.               | password123            |

    <Frame>
      <img src="https://mintcdn.com/superjoin/95T8cmea616drJuC/images/mysql/ms-step3.webp?fit=max&auto=format&n=95T8cmea616drJuC&q=85&s=b8b0b907b03582e7a097d866419f95ff" width="1821" height="870" data-path="images/mysql/ms-step3.webp" />
    </Frame>
  </Step>
</Steps>

## Setting up Amazon RDS

<CardGroup cols={1}>
  <Card title="Looking for RDS?" icon="life-ring" iconType="duotone" href="../rds/overview">
    Head over to the AWS RDS page to get a step by step guide to connect or troubleshoot connectivity.
  </Card>
</CardGroup>