> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# > Domo on MySQL (Beta - RECOMMENDED)

export const InlineImage = ({src, alt = '', height = '1.6em'}) => {
  return <img noZoom src={src} alt={alt} style={{
    display: 'inline',
    verticalAlign: 'start',
    height: height,
    margin: '0'
  }} />;
};

### Intro

MySQL users can connect their data to Domo through Cloud Amplifier native integration. Provide connection parameters and select the tables you want to see as Domo DataSets.

Follow the steps in this article to configure your read-only MySQL-Domo connection with Cloud Amplifier.

### Configure Read-only Connection to MySQL

1. Navigate to the Domo Data Center.

2. (Conditional) If you're not already there, use the sidebar to go to the
   <InlineImage src="/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uR3y.jpg" /> **Data Warehouse**.

3. Select
   <InlineImage src="/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uSeO.jpg" /> **Add New Cloud Account**.

   <Frame>
     <img alt="add new cloud account.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uRaE.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=390abf22c7c1cc8086916df164d4fe6e" style={{width: 500, height: 452}} width="2860" height="2584" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uRaE.jpg" />
   </Frame>

   The **Amplify existing cloud warehouses** modal displays.

4. In the
   **Native integration** section, choose **See More** to see the rest of the options.

   <Frame>
     <img alt="see more.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uTIf.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=6094ef4540f7ea4d381ea899eab2f9dc" style={{width: 501, height: 341}} width="1678" height="1140" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uTIf.jpg" />
   </Frame>

5. Select
   **MySQL**.

   <Frame>
     <img alt="mysql.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/EpEQaVXeYQJOgZLs/images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uRYc.jpg?fit=max&auto=format&n=EpEQaVXeYQJOgZLs&q=85&s=b7a1c8550a2d33da91bc71eec6976bb2" style={{width: 501, height: 335}} width="2122" height="1418" data-path="images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uRYc.jpg" />
   </Frame>

6. Select
   **+ Add New Integration**.

   <InlineImage src="/images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uSL0.jpg" />

   <InlineImage src="/images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uTgr.jpg" />

7. Enter the following connection parameters in the appropriate fields:
   * **Integration name —**
     If you need to update your integration in the future, this is the name to search for in the list of integrations.
   * **Integration description (optional) —**
     Enter any additional information about the integration.
   * **MySQL connection URL —**
     Enter the host and port that represents the MySQL instance you are connecting to. Ex. *[myhost.com](http://myhost.com):3306*
   * **MySQL username —**
     The MySQL instance username that has access to the data you are connecting to.
   * **MySQL password —**
     The password for the MySQL user.

     <Frame>
       <img alt="Screenshot 2024-05-07 at 3.21.47 PM.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/EpEQaVXeYQJOgZLs/images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uWej.jpg?fit=max&auto=format&n=EpEQaVXeYQJOgZLs&q=85&s=ed453ac2c456d532da7aa203a008e74f" style={{width: 555, height: 390}} width="2000" height="1402" data-path="images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uWej.jpg" />
     </Frame>

8. Configure caching options. You can choose whether to automatically check for data updates and at what interval. Learn about Cloud Amplifier
   [caching rules](https://domo-support.domo.com/s/article/4412849158167?language=en_US#caching_rules).

   <Frame>
     <img alt="Screenshot 2024-05-07 at 3.24.52 PM.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uWur.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=9e8dfdee34acb460cc1ed0b210c28551" style={{width: 549, height: 156}} width="2004" height="570" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uWur.jpg" />
   </Frame>

9. Select
   **Next**.

   A success message displays.

10. Select
    **Choose Tables to Connect** to open the table picker.

    <Frame>
      <img alt="choose tables to connect.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/EpEQaVXeYQJOgZLs/images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uXCb.jpg?fit=max&auto=format&n=EpEQaVXeYQJOgZLs&q=85&s=8cfac9851671631b49464092db9dc69c" style={{width: 551, height: 352}} width="2802" height="1791" data-path="images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uXCb.jpg" />
    </Frame>

11. Select from schemas and tables and when you're ready, select
    **Create DataSets**.

    <Frame>
      <img alt="create datasets.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/EpEQaVXeYQJOgZLs/images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uXFp.jpg?fit=max&auto=format&n=EpEQaVXeYQJOgZLs&q=85&s=fe7910a09a6b1a1dcfbbf3632a10bf75" style={{width: 551, height: 330}} width="2988" height="1791" data-path="images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uXFp.jpg" />
    </Frame>

12. (Optional) In the confirmation modal, you can share your DataSets with other Domo users.

    <Frame>
      <img alt="share modal.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/a4f3szIEyPCXGEyk/images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uXZB.jpg?fit=max&auto=format&n=a4f3szIEyPCXGEyk&q=85&s=787cc3bafe733301654696217f80be34" style={{width: 550, height: 313}} width="2001" height="1140" data-path="images/kb/ka0Vq000000BCNd-00N5w00000Ri7BU-0EMVq000000uXZB.jpg" />
    </Frame>

You can now interact with your MySQL DataSets in Domo.

<Frame>
  <img alt="mysql data.jpg" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/EpEQaVXeYQJOgZLs/images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uXcP.jpg?fit=max&auto=format&n=EpEQaVXeYQJOgZLs&q=85&s=012882965e3b51703c72f0e8e85781e6" style={{width: 899, height: 407}} width="4281" height="1938" data-path="images/kb/ka0Vq000000CwrR-00N5w00000Ri7BU-0EMVq000000uXcP.jpg" />
</Frame>
