> This page is for Browser API.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://developers.webflow.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://developers.webflow.com/_mcp/server.

# MySQL

> Configure MySQL as a destination for Data Exports

This guide walks you through configuring MySQL as a destination for your Webflow Analyze and Optimize data export.

## Prerequisites

* If your MySQL database is protected by security groups or other firewall settings, you will need to use the Webflow static IP address: `34.69.83.207/32` to complete Step 1.

## Configuration steps

### Allow access

Create a rule in a security group or firewall settings to allowlist:

* Incoming connections to your host and port (usually `3306`) from the static IP.
* Outgoing connections from ports `1024` to `65535` to the static IP.

> **Note**
>
> **Network allowlisting**
>
> Webflow Static IP: `34.69.83.207/32`

### Create writer user

Create a database user to perform the writing of the source data.

1. Open a connection to your MySQL database.

2. Create a user for the data transfer by executing the following SQL command.

   ```sql
   CREATE USER <username>@'%' IDENTIFIED BY '<some-password>';
   ```

   > **Warning**
   >
   > **Credential character limitations**
   >
   > For user credentials containing special characters, please avoid using the following characters: `@`, `[`, `]`, `/`, `?`, `#`, `"`, `\\`, `+`, space, `&`, `:` as these characters can break connection string parsing.

3. Grant user required privileges on the database.

   ```sql
   GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW ON *.* TO <username>@'%';
   ```

   > **Warning**
   >
   > **If the schema/database already exists**
   >
   > By default, the service creates a new schema (*in MySQL, `schema` is synonymous with `database`*). If you prefer to create the schema yourself before connecting the destination, you must ensure that the writer user has the proper permissions on the schema, using `GRANT ALL PRIVILEGES ON <database_name>.* TO <username>@'%';`

### Add your destination

Use the following details to complete the connection setup: **host name**, **database name**, **port**, your chosen **schema name**, **username**, and **password**.

* Instructions for [Analyze / Optimize for Webflow sites](https://help.webflow.com/hc/en-us/articles/49268564225171)
* Instructions for [Optimize for non-Webflow sites](https://help-optimize.webflow.com/hc/en-us/articles/49271313344019)